Application of Proper Forecasting Technique in Juice Production: A Case Study

Table of contents

1. Introduction

odern production activities are becoming more complex technologically, the basic inputs are becoming expensive and there are lot of restrictions on them. The planning of the production activities is, therefore, essential to put the resources for best use. Planning is a fundamental activity of management. Forecasting forms the basis of planning and it enables the organisation to respond more quickly and accurately to market changes. It plays a crucial role in the development of plans for the future. It is essential for the organisations to know for what level of activities one is planning before investments in inputs i.e. men, machines and materials. It uses many statistical techniques. Therefore, it is also called as Statistical Analysis. It refers to a systematic analysis of past and present circumstances. It is essentially a technique of anticipation. Before making an investment decision, questions may arise like:

? What should be the size of the order and safety stock?

? What should be the capital cost required for the work?

? What should be the capacity of the plant?

? How much labour is required?

The answers to the above questions depend upon the forecast for the future level of operations. The success of a business greatly depends upon the efficient forecasting and preparing for future events. It should be no surprise that forecasts are not always accurate -they are essentially about predicting the future with incomplete information. Nevertheless, forecast inaccuracies, particularly consistent underestimation of revenues and budget surpluses generally draws intense criticism. Forecast accuracy has been a matter of concern and subject of review. In general, the reasons for inaccuracies may fall into the following categories:

? Technical issues, such as data accuracy, forecasting methodology, process and agency structures.

? Effects of fiscal objectives.

? The economic cycle. Forecasting agencies generally review and improve data and models on an ongoing basis, and issues identified in major reviews are generally marginal.

2. II.

3. Aims and Objectives

The main emphasis of this work is to compare the various forecasting techniques prevalent in the industries based on the data obtained from a juice producing factory. In this manuscript an attempt has been made to forecast juice production by using the Moving Average Method, Simple Exponential Smoothing and Least Square Method. The aim is to evaluate the performances in terms of

4. Methodology

This study was carried out on the basis of juice production data collected for the period 2000 to 2011 as shown in the table 1. When demand for a product is neither growing nor declining rapidly and if it does not have seasonal characteristics, a moving average can be useful in removing the random fluctuations for forecasting. Although moving averages are frequently centered, it is more convenient to use past data to predict the following period directly. Although it is important to select the best period for the moving average, there are several conflicting effects of different period lengths. The different moving averages produce different forecasts. The greater the number of periods in the moving average, the greater the smoothing effect. If the underlying trend of the past data is thought to be fairly constant with substantial randomness, then a greater number of periods should be chosen. The formula for a simple moving average is

F t = ( A t-1 + A t-2 + A t-3 + A t-n ) n(1)

Where , F t = Forecast for the coming period, n = Number of period to be averaged n and A t-1 , A t-2 , A t-3 = Actual occurrences in the in the past period, two periods ago, three periods ago and so on respectively.

Equal weighting is given to each of the values used in the moving average calculation, whereas it is reasonable to suppose that the most recent data is more relevant to current conditions. An n period moving average requires the storage of (n-1) value to which is added the latest observation. This may not seem much of a limitation when only a few items are considered. The moving average calculation takes no account of data outside the period of average, so full use is not made of all the data available. The use of the unadjusted moving average as a forecast can cause misleading results when there is an underlying seasonal variation.

5. b) Simple Exponential Smoothing Method

In the previous forecasting method, the major drawback is the need to continually carry a large amount of historical data. As each new piece of data is added in these methods, the oldest observation is dropped, and the new forecast is calculated. The reason this is called exponential smoothing is that each increment in the past is decreased by (1-?).This method provides short term forecasts. The simplest formula is New forecast = Old forecast + ? (Latest Observation -Old Forecast)

Or more mathematically,

F t = F t-1 + ? (A t-1 -F t-1 ).

(2) Where, Ft = The exponentially smoothed forecast for period t, F t-1 = The exponentially smoothed forecast made for the prior period, A t-1 = The actual demand in the prior period, ? = The desired response rate, or smoothing constant.

The value of smoothing constants ? varies from 0 to 1. The higher value of ? (i.e. the nearer to 1), the more sensitive the forecast becomes to current conditions, whereas the lower the value, the more stable the forecast will be, i.e. it will react less sensitively to current conditions. Here the value of alpha is taken as 0.3.Greater weight is given to more recent data. All past data are incorporated there is no cut-off point as with moving averages. Less data needs to be stored than with the longer period moving averages. Like moving averages it is an adaptive forecasting system. That is, it adapts continually as new data becomes available and so it is frequently incorporated as an integral part of stock control and production control systems. To cope with various problems (trend, seasonal factors, etc) the basic model needs to be modified. Whatever form of exponential smoothing is adopted, changes to the model to suit changing conditions can simply be made by altering the value of ?. The selection of the smoothing constant ? is done through trial-error by the researcher/analyst. It is done by testing several values of ? (within the range 0 to 1) and selecting one which gives a forecast with the least error (one can take standard error). It has been found that values in the range 0.1 to 0.3 provide a good starting point.

6. c) Least Squares Method

This is the mathematical method of obtaining the line of best fit between the dependent variable and an independent variable. In this, the sum of the square of the deviations of the various points from the line of best fit is minimum or least. (5)

These two equations are called normal equations. It is useful for long-term forecasting of major occurrences and aggregate planning. The major restriction in using linear forecasting is that past data and future projections are assumed to fall about a straight line. Although, this does limits its application.

7. d) Evaluating the Forecast Accuracy

There are many ways to measure forecast accuracy. Some of these measures are the mean absolute forecast error, called the MAD (Mean Absolute Deviation), the mean absolute percentage error (MAPE) and the mean square error (MSE). This error estimate helps in monitoring erratic demand observations. In addition, they also help to determine when the forecasting method is no longer tracking actual demand and it need to be reset. For this tracking signals are used to indicate any positive or negative bias in the forecast. The mean absolute deviation (MAD) is also important because of its simplicity and usefulness in obtaining tracking signals. MAD is the average error in the forecasts, using absolute values. It is valuable because MAD, like the standard deviation, measures the dispersion of some observed value from some expected value. The only difference is that like standard deviation, the errors are not squared. Standard error a square root of a function, it is often more convenient to use the function itself. This is called the mean square error (MSE) or variance. The mathematical formulas may be used while evaluating data are

8. result analysis

In this study, we used the data for juice production for the period 2000-01 to 2010-2011. All the three methods are applied one by one and their performance evaluated in terms of MAD, MAPE and MSE.

9. a) Moving Average Method

10. Discussion

Initially time series plot (Figure 1) was created to determine the trends in the juice production from 2003 to 2011, the graph shows an increasing trend in juice production during the study period and hence showed that the series was not stationary. It is very clear from the graph that the trend line of Least Square Average method flow on the actual trend line of juice production. The trend line of Simple exponential method is far away from the actual trend line. And finally the performance of the various methods evaluated on the basis of MAPE, MAD and MSE which is shown in the table 6. By comparing the performance of the methods, it was found that Least Square method have least value of MAPE (15.74%), MAD (0.25) and MSE (0.09) and hence the results produced by the least square method have less error and more accurate than the other method.

11. VI.

12. Conclusion

Forecasting of juice production done by using statistical methods, (Moving Average method, Simple Exponential Method and Least Square Method). Statistical methods are chosen because for their rich historic data and ease of their use. Finally, their performance evaluated by comparing the MAPE, MAD and MSE obtained from the different methods. The results show that least Square method is more accurate than the other methods.

The forecasting technique may be different for different industries. It depends upon the variable factors like place, manpower skill, equipment capacity, raw material availability, inventory characteristics and management policies etc. Hence this work may be extended to other industries.

Figure 1. 4 )?
4of the line, a is the y -intercept. The value of a and b is calculated by using following equations. a = ?? ? -b?? ? (???? -?? ??. ? ?? ? ? ?? 2 -?? ?? ? 2
Figure 2. Table 1 :
1
company
S. No. Year Production (in millions)
1 2000-01 16.6
2 2001-02 19.3
Figure 3. Table 2 :
2
Technique Measures
Mean Squared The average of squared errors
Error (MSE) over the sample period
Mean Error (ME) The average dollar amount or
percentage points by which
forecasts differ from outcomes
Mean Percentage The average of percentage errors
Error (MPE) by which forecasts differ from
outcomes
Mean Absolute The average of absolute dollar
Error (MAE) amount or percentage points by
which a forecast differs from an
outcome
Mean Absolute The average of absolute
Percentage Error percentage amount by which
(MAPE) forecasts differ from outcomes
IV.
Figure 4. Table 3 :
3
Application of Proper Forecasting Technique in Juice Production: A Case Study
Year 2013
XIII Issue v v v IV Version I
Volume
D D D D ) G
(
S. No. 1 2 3 4 5 Year 2000-01 2001-02 2002-03 2003-04 2004-05 Production (in millions) P 16.6 19.3 20.8 23.8 26.5 Forecast F 18.9 21.3 Error E 4.9 5.2 Squared Error E 2 24.01 27.04 Absolute Percentage Error (E/P)x 100 20.59 19.62 Global Journal of Researches in Engineering
6 2005-06 29 23.7 5.3 28.09 18.28
7 2006-07 31.1 26.43 4.67 21.78 15.01
8 2007-08 33.4 28.87 4.53 20.55 13.57
9 2008-09 36.4 31.17 5.23 27.39 14.38
10 2009-10 38.9 33.63 5.27 27.74 13.54
11 2010-11 40.7 36.23 4.47 19.95 10.97
Figure 5. Table 4 :
4
S. No. Year Production Forecast Error Squared Error Absolute
(in millions) P F E E 2 Percentage Error
(E/P)x 100
1 2000-01 16.6
2 2001-02 19.3 16.6 2.7 7.29 13.99
3 2002-03 20.8 16.87 3.93 15.44 18.89
4 2003-04 23.8 17.26 6.54 42.73 27.47
5 2004-05 26.5 17.92 8.58 73.67 32.39
6 2005-06 29 18.78 10.22 104.55 35.26
7 2006-07 31.1 19.80 11.30 127.75 36.34
8 2007-08 33.4 20.93 12.47 155.56 37.34
9 2008-09 36.4 22.17 14.23 202.35 39.08
10 2009-10 38.9 23.60 15.30 234.17 39.34
11 2010-11 40.7 25.13 15.57 242.50 38.26
c) Least Square Method
Figure 6. Table 5 :
5
Year 2013
46
I
XIII Issue v v IV Version X 1 2 3 4 Production (in millions) P 16.6 19.3 20.8 23.8 XP 16.6 38.6 62.4 95.2 X 2 1 4 9 16 P 2 275.56 372.49 432.64 566.44 Forecast F 16.52 18.98 21.43 23.88 Error E 0.08 0.32 0.63 0.08 Squared Error E 2 0.01 0.10 0.40 0.01 Absolute Percentage Error (E/P)x 100 0.48 1.69 2.94 0.34
Volume 5 6 7 26.5 29 31.1 132.5 174 217.7 25 36 49 702.25 841 967.21 26.33 28.78 31.23 0.17 0.22 0.13 0.03 0.05 0.02 0.65 0.76 0.42
( D D D D ) G 8 9 33.4 36.4 267.2 327.6 64 81 1115.56 1324.96 33.69 36.14 0.29 0.26 0.08 0.07 0.86 0.72
Global Journal of Researches in Engineering 10 11 ?X=66 Mean X = 6 Therefore general equation for forecast is F = 14.07 + 2.45X 38.9 389 100 1513.21 38.59 40.7 447.7 121 1656.49 41.04 ?P=66 ?XP=66 ?X 2 =66 ?P 2 =66 ? F =66 Mean P = 28.77 a= 14.07 b= 2.45 0.31 0.34 ?E=2.83 ?E 2 =0.97 0.10 0.12 Forecast of juice production 23.8 26.5 29 31.1 33.4 36.4 38.9 40.7 18.9 21.3 23.7 26.43 28.87 31.17 33.63 36.23 17.26 17.92 18.78 19.8 20.93 22.17 23.6 25.13 23.88 26.33 28.78 31.23 33.69 36.14 41.04 38.59 actual production 0.80 0.83 ?=10.48 moning average method Production Millions simple exponential method
Least square method
Production Year
© 2013 Global Journals Inc. (US)
Figure 7. Table 6 :
6
best forecasting method for juice production
Measures Moving Simple Least Square
of accuracy Average Exponential Method
Method Method
MAPE 15.74 % 31.83 % 0.95%
MAD 4.95 10.08 0.25
MSE 24.57 120.60 0.09
1

Appendix A

Appendix A.1

Appendix B

  1. The Delphi technique as a forecasting tool: issues and analysis. Gene Rowea , George Wright . International Journal of Forecasting 1999. 15 p. .
  2. Forecasting with cue information: A comparison of multiple regression with alternative forecasting approaches. K Nikolopoulos , P Goodwin , A Patelis , V Assimakopoulos . European Journal of Operational Research 2007. 180 p. .
  3. Judgmental forecasting: A review of progress over the last 25 years. Michael Lawrence , Paul Goodwin , O' Marcus , Dilek Connor , Önkal . International Journal of Forecasting 2006. 22 (3) p. .
  4. Demand Forecasting and Production Planning for Highly Seasonal Demand Situations: Case Study of a Pressure Container Factory. Pisal Yenradeea , Anulark Pinnoi , Amnaj Charoenthavornying . Science Asia 2001. 27 p. .
  5. Introduction to time series and forecasting, P J Brockwell , R A Davis . 1996. Springer.
  6. Statistical models for milk production in India. Satya Pal , V Ramasubramanium , S C Mehta . Journal of Indian society of Agriculture and statistical 2007. 2007. 61 (2) p. .
  7. Forecasting-Methods and applications, S Markridas , S C Wheelwright , R J Hyndman . 1998. New York: John Wiley and sons.
  8. Forecasting time series using a methodology based on autoregressive integrated moving average and genetic programming. Yi-Shian Lee , Lee-Ing Tong . Knowledge-Based Systems 2011. 2011. 24 p. .
Notes
1
© 2013 Global Journals Inc. (US)
Date: 2013-01-15