Research Article | Open Access
A Study of Time Series Model for Predicting Jute Yarn Demand: Case Study
In today’s competitive environment, predicting sales for upcoming periods at right quantity is very crucial for ensuring product availability as well as improving customer satisfaction. This paper develops a model to identify the most appropriate method for prediction based on the least values of forecasting errors. Necessary sales data of jute yarn were collected from a jute product manufacturer industry in Bangladesh, namely, Akij Jute Mills, Akij Group Ltd., in Noapara, Jessore. Time series plot of demand data indicates that demand fluctuates over the period of time. In this paper, eight different forecasting techniques including simple moving average, single exponential smoothing, trend analysis, Winters method, and Holt’s method were performed by statistical technique using Minitab 17 software. Performance of all methods was evaluated on the basis of forecasting accuracy and the analysis shows that Winters additive model gives the best performance in terms of lowest error determinants. This work can be a guide for Bangladeshi manufacturers as well as other researchers to identify the most suitable forecasting technique for their industry.
To stay competitive in the global business environment, effective planning regarding scheduling, inventory, production, distribution, purchasing, and so on is very important as it is considered as the backbone of fruitful operations. Appropriate prediction of products plays a pivotal role in reducing unnecessary inventory and smoothing planning issues which result in increasing profit. Many organizations have failed due to the fault estimation. Prediction refers to the technique to probe the future event or occurrence. An event may be demand of a product, price of a commodity, unemployment rate, and so on. In modern business environment, satisfying customer’s demand at right time at right quantity is the main driving force for generating profit. So, to ensure product availability with the lowest possible cost, prediction with as much accuracy as possible is very necessary. As prediction is an uncertain process, it is not so much easy task to predict consistently what will happen in future. Product diversification, short life cycle of product, rapid technological advances, and so on make prediction of product demand more difficult and too much challenging.
There are enormous research works in the arena of forecasting method selection with time series data. Time series data may be different types like electric power consumption, sales/demand of a product, price of commodities, and so on. Several authors have worked on time series analysis [1–3]. Cox Jr. and Loomis  conducted a 25-year survey on time series analysis and suggested some possible ways to improve the forecasting techniques. The sole purpose of their work was to observe the stimulus of text books on forecasting learning. Ryu and Sanchez  constructed a framework for the evaluation of the most appropriate forecasting method at an institutional food service dining facility. The authors applied different forecasting methods and calculated measures of forecasting accuracy using MAD, MSE, MAPE, MPE, RMSE, and Theil’s -statistic. The analysis showed multiple regression analysis as the most appropriate method among several alternatives.
Wallström and Segerstedt  applied Croston forecasting technique and single exponential smoothing approach to develop flexible and robust supply chain forecasting systems for slow moving or intermittent demand. The authors measured the apprehended performance of methods based on estimated forecasting errors. Sanwlani and Vijayalakshmi  conducted time series analysis for forecasting sales. Different statistical methods, namely, ARIMA, Holt, Winters, and exponential smoothing, were used and absolute percentage error (APE) was used for comparing the performance of different forecasting methods. Hossain and Abdulla  performed time series analysis on secondary data of yearly jute production in Bangladesh over the period of 1972 to 2013. The purpose of the work was to identify the Autoregressive Integrated Moving Average (ARIMA) model for forecasting the production of jute in Bangladesh. Davies et al.  measured the application of time series models including ARIMA and exponential smoothing for future requirements of volatile inventory. They also applied Monte Carlo simulation for forecasting and compared the output of simulation with time series forecasts. The contribution of the paper is to develop a framework that combines time series modeling and Monte Carlo simulation for forecasting. Miller et al.  did a comparison of different forecasting methods, namely, Naïve Approach, simple moving average, weighted moving average, exponential smoothing, and Linear Least Square Regression, for forecasting food production.
Matsumoto and Ikeda  examined the demand forecasting of an auto-part using time series analysis. The objective of the study was to examine the effectiveness of forecasting for remanufactured products by time series analysis. Li et al.  used vector forecasting model for fuzzy time series which were capable of dealing with ambiguity. The contribution of the work was to improve forecasting capability through the expansion of the vector forecasting model. Time series analysis is also used in tourism sector. Weatherford and Kimes  applied different forecasting methods on hotel revenue management and recommended that exponential smoothing, pickup, and moving average models were the most suitable for forecasting as well as revenue generation.
Different qualitative forecasting methods are used by managers to make forecast of product demand. Qualitative methods include past experience, best guess, or group discussion. To aid management in planning decisions, different quantitative techniques are available in the literature. The aim of this study is to develop a framework for identifying the most appropriate forecasting method for predicting jute yarn demand of a Bangladeshi jute yarn manufacturer. As no forecasting technique can provide accurate forecast, this paper can be a reliable guideline to reduce the deviation between actual and predicted values.
The sole purpose of this study is to develop a framework that justifies the viability of different forecasting methods and select the best one with the least possible forecasting errors. Forecasting is a powerful tool to reduce the uncertainty in demand of product and help the manager to project demand for upcoming periods. In this study, several quantitative forecasting models like simple moving average method, single exponential method, double exponential method (Holt’s), Winters method, decomposition method, and so on have been utilized. To identify the best one, three error determinants, namely, mean absolute deviation (MAD), Mean Absolute Percentage Error (MAPE), and mean square deviation (MSD), are calculated. All calculations are done by Minitab 17 package. The necessary data in this study was collected from Akij Jute Mills, Akij Group Ltd. in Noapara, Jessore, on weekly basis over four-year periods (1st week 2010 to 52th week 2013). To analyze data using statistical techniques, the historical demand data of jute yarn product was collected. The detailed descriptions of each method used in this study are illustrated in the following sections.
2.1. Forecasting Methods
2.1.1. Simple Moving Average Method (SMA)
Simple moving average (SMA) or rolling average is the arithmetic mean of observations of the full data set and uses the arithmetic mean as the predictor of the future period. This method is used to smooth out short-term deviations of time series data and indicate long-term trends or cycles. The equation of SMA is as follows:where is forecast for time period , is demand in period , and is number of periods in the moving average.
2.1.2. Single Exponential Smoothing (SES) Method
This sophisticated method is a kind of weighted averaging method which estimates the future value based on previous forecast plus a percentage of the forecasted error. It is easy to implement and compute as it does not need maintaining the history of previous input data. It fades uniformly the effect of unusual data. The equation of SES is as follows:where is forecast for time period , is forecast for the previous period, is actual demand for the previous period, and is smoothing constant .
2.1.3. Double Exponential Smoothing (Holt’s Method)
Double exponential smoothing or Holt’s method by Holt (1957) is used to forecast data having linear trend. It is an extension of simple exponential smoothing. Holt’s method smooths both trend and slope in the time series using two different smoothing constants (alpha for the level and gamma for the trend).where is forecast for h periods into the future, is level estimate at time , is trend (slope) estimate at time , are periods to be forecast into future, is smoothing constant for level , and is smoothing constant for trend .
2.1.4. Winters Method
When both trend and seasonality are present in data set, this procedure can be used. It is used to smooth data employing a level component, a trend component, and a seasonal component at each period and provides short to medium range forecasting. There are two types of model: multiplicative and additive. Multiplicative model is used when the magnitude of the seasonal pattern varies with the size of the data. Additive model is just opposite to multiplicative model. The following equations are Winters method smoothing equations.
Smoothing equation for multiplicative model:
Smoothing equation for additive model: where is one-period ahead of forecast at time , is level estimate at time , is trend estimate at time , is seasonal estimate at time , is data value at time , is seasonal period, is smoothing constant for level , is smoothing constant for trend , and is smoothing constant for seasonality .
2.1.5. Trend Analysis
Trend analysis fits a general model to multiple time series data having trend pattern and provides idea to traders about what will happen in the future based on historical data. Trend can be linear, quadratic, or S-curve. A general linear type trend equation has the following form:where is forecast for time period , is specified number of time periods, is intercept of the trend line, is slope of the line, is number of periods, and is value of the time series.
Decomposition technique is used to separate the time series into linear trend and seasonal components, as well as error. Seasonal component can be additive or multiplicative with the trend. When seasonal component is present in time series, it is used to examine the nature of the component parts.
2.2. Measures of Forecasting Accuracy
Forecasting accuracy plays a vital role when deciding among several forecasting alternatives. Here, accuracy refers to forecasting error which is the deviation between the actual value and forecasted value of a given period. In this study, three forecasting error determinants are used: mean absolute deviation (MAD), the mean squared error (MSE), and the Mean Absolute Percentage Error (MAPE). MAD is the average absolute difference between actual value and value that was predicted for a given period, MSE is the average of squared errors, and MAPE is the average of absolute percent error. The formulas used to calculate above stated errors arewhere is actual demand for time period , is forecast demand for time period , is specified number of time periods, and is forecast error = ).
3. Prototype Example and Result Analysis
The sole purpose of this study is to develop a framework for the future researchers as well as Bangladeshi manufacturers that can help to identify an appropriate forecasting method based on its error determinants. For real case demonstration, a practical case study on Akij Jute Mills, Akij Group Ltd. in Noapara, Jessore, was conducted. Eight forecasting methods are used and measures of forecasting accuracy, namely, mean absolute deviation (MAD), Mean Absolute Percentage Error (MAPE), and mean square deviation (MSD), are calculated using Minitab 17 package.
Figure 1 shows the time series plot of 208-week demand data of jute yarn from year 2010 to year 2013. It indicates that demand fluctuates over period to period. The trends of demand in 2010, 2011, and 2012 are quite the same with little fluctuations. Demand was steady until 4 weeks and then sharply increased at week 5. It continued as steady and then suddenly decreased at week 9. The trend of demand found in weeks 32–35 was highest for all four years and here the seasonality was found. Average demand has increased from year 2010 to year 2012. On the other hand, demand data corresponding to year 2013 showed great change in demand at every week and these values were greater than the previous years. The lowest value of demand was above 1000 tons whereas it was the highest demand for year 2010. Table 1 depicts different forecasting errors for different forecasting periods under simple moving average method. In simple moving average method, fourteen trials are taken through putting different values of . Fourteen sets of error determinants are measured and least values of MAD, MAPE, and MSE are obtained when value of forecasting period is 15 weeks. The values of MAD, MAPE, and MSE for 15 weeks are varied between 70.5–135, 8.3–15.3, and 19431.2–33976.4, respectively. A graphical representation of actual demand versus forecasted demand for simple moving average method is portrayed in Figure 2. There are a sudden increase and sudden decrease in actual demand while forecasted demand fluctuates between the highest and lowest value of actual demand. The accuracy measures are 13.1, 117.4, and 26912.1 for MAPE, MAD, and MSD, respectively. On the other hand, to determine optimal smoothing constant (α) in single exponential smoothing method, nine trials are made and least forecasting errors are obtained at higher value of smoothing constant. Different values of forecasting errors with varying smoothing constant are shown in Table 2. The values of MAPE, MAD, and MSE are varied between 6.5–13.1, 53.6–116.8, and 15457–29939.5, respectively. It is clear from Table 2 that the values of MAPE, MAD, and MSE decrease with increase of the value of smoothing constant. Figure 3 shows that the fluctuation of actual and forecasting demand is approximately same for single exponential smoothing method. It is found that the minimum errors occurred at optimum smoothing constant . In Holt’s method, nine trials are performed with varying smoothing constants (both level and trend) from 0.1 to 0.3 which is shown in Table 3. Figure 4 shows the comparison of actual demand of jute yarn in ton with the forecasted demand in 2010–2013 using Holt’s method at most suitable combination of smoothing constants. The lowest values of errors are achieved at and .
From trend analysis on jute yarn demand data of 208 weeks, obtained trend equation is which is shown in Figure 5. Figure 5 also shows the forecasting errors as well as forecasted values with respect to the actual demand. Besides these, two types of Winters model (multiplicative and additive model) are used to determine the errors. Total 27 trials have been conducted by varying the values of three smoothing constants (α, γ, and ) ranging from 0.1 to 0.3. For both cases, seasonal length is about 52 weeks. Twenty-seven sets of forecasting errors for 27 trials are obtained for multiplicative and additive Winters model and shown in Table 4. Optimum smoothing constants for additive and multiplicative models and corresponding MAD, MAPE, and MSE are given in Figures 6 and 7, respectively. The figures show that minimum errors are obtained for both models at , , and But Winters additive model provides more satisfactory result than multiplicative model. Multiplicative and additive decomposition models considering both seasonal plus trend and only seasonal pattern are used to calculate measures of accuracy. Table 5 summarizes the results of both models and indicates that multiplicative decomposition model with trend and seasonal effect has minimum errors. Additive model having trend and seasonal effect also provides least error values.
Considering all the calculation and analysis, the entire output using eight different forecasting techniques is summarized in Table 6. Results show that differences are present among applied techniques. MAD values vary from 40.58 to 134.16; MAPE values of different forecasting methods vary from 5.06 to 15.39. The maximum value of MSD (33243.4) is found by moving average method while the lowest value (4705) is obtained by Winters additive method. Comparing the performance of anticipated methods, Winters additive model displays the minimum forecasting error values which indicates the greatest accuracy and implies the suitability of this method.
The main goal of this study is to determine the most appropriate forecasting technique for upcoming sale of jute yarn for jute products manufacturing industry in Bangladesh. The forecasting method will be selected on the basis of least forecasting errors, that is, minimum values of MAPE, MAD, and MSD. For this purpose, different time series analysis is performed on 208-week demand data using Minitab 17 package and measures of accuracy are calculated. Performance of eight forecasting methods is evaluated and results show that the suitable method is Winters additive model to forecast their actual demand. This study can help the industry as well as others Bangladeshi manufacturers to reduce the deviation between actual and forecasted demand through the selection of the contingent forecasting method.
Conflicts of Interest
The authors declare that they have no conflicts of interest.
- J. Strasheim, “Demand forecasting for motor vehicle spare parts,” Journal of Industrial Engineering, vol. 6, no. 2, pp. 18-19, 1992.
- C. Floros, “Forecasting the UK unemployment rate: model comparisons,” vol. 2, pp. 57–72, 2005.
- Q. Zhu, Y. Guo, and G. Feng, “Household energy consumption in China: Forecasting with BVAR model up to 2015,” in Proceedings of the 2012 5th International Joint Conference on Computational Sciences and Optimization, CSO 2012, pp. 654–659, 2012.
- J. E. Cox Jr. and D. G. Loomis, “Improving forecasting through textbooks: a 25 year review,” International Journal of Forecasting, vol. 22, no. 3, pp. 617–624, 2006.
- K. Ryu and A. Sanchez, “The evaluation of forecasting methods at an institutional foodservice dining facility,” The Journal of Hospitality Financial Management, vol. 11, no. 1, pp. 27–45, 2013.
- P. Wallström and A. Segerstedt, “Evaluation of forecasting error measurements and techniques for intermittent demand,” International Journal of Production Economics, vol. 128, no. 2, pp. 625–636, 2010.
- M. Sanwlani and M. Vijayalakshmi, “Forecasting sales through time series clustering,” International Journal of Data Mining & Knowledge Management Process, vol. 3, no. 1, pp. 39–56, 2013.
- M. M. Hossain and F. Abdulla, “Jute production in Bangladesh: a time series analysis,” Journal of Mathematics and Statistics, vol. 11, no. 3, pp. 93–98, 2015.
- R. Davies, T. Coole, and D. Osipyw, “The application of time series modelling and monte carlo simulation: forecasting volatile inventory requirements,” Applied Mathematics, vol. 05, no. 08, pp. 1152–1168, 2014.
- J. L. Miller, C. S. McCahon, and B. K. Bloss, “Food production forecasting with simple time series models,” Hospitality Research Journal, vol. 14, p. 21, 1991.
- M. Matsumoto and A. Ikeda, “Examination of demand forecasting by time series analysis for auto parts remanufacturing,” Journal of Remanufacturing, vol. 5, no. 1, 2015.
- S.-T. Li, S.-C. Kuo, Y.-C. Cheng, and C.-C. Chen, “A vector forecasting model for fuzzy time series,” Applied Soft Computing Journal, vol. 11, no. 3, pp. 3125–3134, 2011.
- L. R. Weatherford and S. E. Kimes, “A comparison of forecasting methods for hotel revenue management,” International Journal of Forecasting, vol. 19, no. 3, pp. 401–415, 2003.
Copyright © 2017 C. L. Karmaker et al. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.