{"id":168,"date":"2018-10-15T09:09:56","date_gmt":"2018-10-15T09:09:56","guid":{"rendered":"http:\/\/mgmtp04.epgpbooks.inflibnet.ac.in\/?post_type=chapter&#038;p=168"},"modified":"2018-10-18T04:28:31","modified_gmt":"2018-10-18T04:28:31","slug":"time-series-methods-of-forecasting","status":"publish","type":"chapter","link":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/chapter\/time-series-methods-of-forecasting\/","title":{"rendered":"Time Series Methods of Forecasting"},"content":{"raw":"<div><\/div>\r\n<div>\r\n\r\n&nbsp;\r\n\r\n<strong>11.1 <\/strong><strong>OBJECTIVES<\/strong>\r\n\r\n&nbsp;\r\n\r\nThis chapter would help students to understand:\r\n<ul>\r\n \t<li>Importance of time period in fluctuation of data<\/li>\r\n \t<li>Role of variation of data in selecting a particular forecasting technique<\/li>\r\n \t<li>Methods of forecasting when variation in demand is random: Simple Moving Average, Weighted Moving Average, Exponential Smoothing<\/li>\r\n<\/ul>\r\n&nbsp;\r\n\r\n<strong>11.2 INTRODUCTION\u00a0<\/strong>\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\">Time series models of forecasting require past data to fulfill objective of prediction. This type of data is recorded over a period of time\u00a0 taken at regular intervals (e.g. hourly, weekly, monthly, annually).\u00a0 The\u00a0 data collected over a selected time period can be regarding sales of a product, absenteeism rate, operating time on a machine, profits etc. For example, sales figures collected over a period of four weeks can be used to predict sales of fifth week.<\/p>\r\n&nbsp;\r\n<p style=\"text-align: justify\">The most important aspect to understand is the time interval for which data has to be collected. Should a particular data be collected hourly,\u00a0 daily, weekly, monthly or\u00a0 at\u00a0 any other\u00a0 rate? Data\u00a0 fluctuation\u00a0 is directly proportional to time interval selected. It can show a trend, seasonal, cyclical or random variation. The fluctuation behavior of data would be instrumental in\u00a0 deciding proper forecasting technique.\u00a0 Time intervals\u00a0 are\u00a0 always discussed in relative sense. Terms such as short, medium and long term are relative to the context in which they\u00a0<span style=\"text-align: initial;font-size: 1em\">are used. Table 11.1.1 shows type of forecasting technique some of which would be discussed in this chapter in context of time period. Short term period is referred as data collected over a time period of less than 3 months; medium term: three months to two years and long term as more than two years.<\/span><\/p>\r\n\r\n<\/div>\r\n<div>\r\n<table class=\"aligncenter\" style=\"width: 682px;height: 282px\" border=\"1\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 667.063px\" colspan=\"3\"><strong>Table 11.1.1<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 118.063px\"><strong>Time period<\/strong><\/td>\r\n<td style=\"width: 235.063px\"><strong>Data pattern<\/strong><\/td>\r\n<td style=\"width: 286.063px\"><strong>Forecasting technique<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 118.063px\">Short term: less than 3 months<\/td>\r\n<td style=\"width: 235.063px\">Data \u00a0does \u00a0not \u00a0show \u00a0any \u00a0particular pattern \u00a0or variation.<\/td>\r\n<td style=\"width: 286.063px\">\r\n<ul>\r\n \t<li>Simple Moving Average,<\/li>\r\n \t<li>Weighted \u00a0moving \u00a0average and<\/li>\r\n \t<li>Exponential Smoothing<\/li>\r\n<\/ul>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 118.063px\">Medium term: 3 months to two years<\/td>\r\n<td style=\"width: 235.063px\">Data either repeats periodically or move along a particular direction i.e. upward or downward<\/td>\r\n<td style=\"width: 286.063px\">\r\n<ul>\r\n \t<li>Seasonal and Trend Variation<\/li>\r\n<\/ul>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 118.063px\">Long term: more than 2 years<\/td>\r\n<td style=\"width: 235.063px\">Data \u00a0shows \u00a0repeated \u00a0pattern \u00a0but \u00a0at irregular intervals with irregular intensity<\/td>\r\n<td style=\"width: 286.063px\">\r\n<ul>\r\n \t<li>Cyclical method<\/li>\r\n<\/ul>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n&nbsp;\r\n<p style=\"text-align: justify\">Also selected time period has an influence over accuracy of prediction. If the data is collected for a very long term period it might provide\u00a0 good\u00a0 results\u00a0 but\u00a0 older\u00a0 data may not have relevance\u00a0 in\u00a0 present\u00a0 scenario. Likewise, if only recent data is used it might not be sufficient to give reliable prediction results. Thus, time period and availability of data over that time period influences accuracy of forecasting.<\/p>\r\n&nbsp;\r\n<p style=\"text-align: justify\">In previous modules we have discussed four ways in which data can fluctuate. These methods have been briefed here with some illustrations.<\/p>\r\n\r\n<ul>\r\n \t<li style=\"text-align: justify\"><strong><em>Seasonal: <\/em><\/strong>Amount of traffic increases twice every day and shows similar pattern next working day. So, data regarding traffic will show a repetitive cycle with equal time intervals.<\/li>\r\n \t<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Cyclical: <\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">Fashion keeps on changing with one style of clothing which had gone out of fashion would again be considered in vogue. But this happens at irregular time intervals where it is very difficult to predict when one style will go out of fashion and when it will reappear.<\/span><\/li>\r\n \t<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Trend: <\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">A mobile phone company might see an upward trend of sale of their smart phones over last six- eight months but with competitor launching a new variant the company\u2019s sale might start to slow down weekly. So, the sale of smart phones showed an increasing trend over monthly data whereas decrease in sale of smart phones showed a decreasing trend over weekly data.<\/span><\/li>\r\n \t<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Random: <\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">Fluctuation of a share in stock market shows an irregular trend and its fluctuation is recorded hourly or even at smaller time period.<\/span><\/li>\r\n<\/ul>\r\n&nbsp;\r\n<p style=\"text-align: justify\">Thus, which forecasting model a firm should select, depends on:<\/p>\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li>Time horizon to forecast<\/li>\r\n \t<li>Availability of data<\/li>\r\n \t<li>Accuracy required<\/li>\r\n<\/ul>\r\n&nbsp;\r\n<p style=\"text-align: justify\">Taking these aspects into consideration following section discusses three forecasting techniques in context of random variation of data. These methods are:<\/p>\r\n\r\n<ul>\r\n \t<li>Simple Moving Average<\/li>\r\n \t<li>Weighted Moving Average<\/li>\r\n \t<li>Exponential Smoothing<\/li>\r\n<\/ul>\r\n&nbsp;\r\n\r\n<strong>11.3 SIMPLE MOVING AVERAGE\u00a0<\/strong>\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\">A data is considered to follow random fluctuations if it is neither increasing nor decreasing over a short term period and also does not shown any seasonal pattern over medium term. The absence of pattern in the data is reflected when it is recorded with short time intervals such as hourly, daily or weekly. The method is called as moving average because forecasted data keeps moving from one time period to another. For instance, suppose we have data for last 12 weeks and we need to forecast for 6th week by taking past data of five weeks. This can be done by averaging actual data of first five weeks and calculating its simple average. Similarly forecast for 7th week would require data of past five weeks i.e. from 2nd to 6th week and in same fashion data keeps on moving by leaving the earliest week and adding the most recent week data.<\/p>\r\n&nbsp;\r\n<p style=\"text-align: justify\">This has been illustrated by following example:<\/p>\r\n&nbsp;\r\n<p style=\"text-align: justify\"><strong><em>Example 11.2.1: <\/em><\/strong>For the following weekly demand for 10 weeks (as shown in Table 11.2.1) predict demand from 4th week to 11th week by using past 3 weekly data.<\/p>\r\n\r\n<table class=\"aligncenter\" style=\"width: 526px\" border=\"1\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 72.0625px\" colspan=\"11\"><strong>Table 11.2.1<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 72.0625px\"><strong>Week<\/strong><\/td>\r\n<td style=\"width: 41.0625px\">1<\/td>\r\n<td style=\"width: 46.0625px\">2<\/td>\r\n<td style=\"width: 47.0625px\">3<\/td>\r\n<td style=\"width: 46.0625px\">4<\/td>\r\n<td style=\"width: 46.0625px\">5<\/td>\r\n<td style=\"width: 46.0625px\">6<\/td>\r\n<td style=\"width: 46.0625px\">7<\/td>\r\n<td style=\"width: 45.0625px\">8<\/td>\r\n<td style=\"width: 46.0625px\">9<\/td>\r\n<td style=\"width: 45.0625px\">10<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 72.0625px\"><strong>Actual\u00a0<\/strong><strong>Demand<\/strong><\/td>\r\n<td style=\"width: 41.0625px\">800<\/td>\r\n<td style=\"width: 46.0625px\">1400<\/td>\r\n<td style=\"width: 47.0625px\">1000<\/td>\r\n<td style=\"width: 46.0625px\">1500<\/td>\r\n<td style=\"width: 46.0625px\">1500<\/td>\r\n<td style=\"width: 46.0625px\">1300<\/td>\r\n<td style=\"width: 46.0625px\">1800<\/td>\r\n<td style=\"width: 45.0625px\">1700<\/td>\r\n<td style=\"width: 46.0625px\">1300<\/td>\r\n<td style=\"width: 45.0625px\">1700<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n&nbsp;\r\n<p style=\"text-align: justify\">To predict for 4th week by taking past data calculate simple average of actual demand of week 1, week 2 and week<\/p>\r\n&nbsp;\r\n\r\nAverage (4th week)\r\n\r\n&nbsp;\r\n\r\n= Actual demand of (week 1 + week 2 + week 3) \/ 3\r\n\r\n= (800 + 1400 + 1000)\/3\r\n\r\n= 1067 units\r\n\r\n&nbsp;\r\n\r\nAverage (5th week)\r\n\r\n&nbsp;\r\n\r\n= Actual demand of (week 2 + week 3 + week 4) \/ 3\r\n\r\n= (1400 + 1000 + 1500)\/3\r\n\r\n= 1300 units\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\">Similarly forecasted demand can be calculated for each week as shown in Table 11.3.2<\/p>\r\n\r\n<\/div>\r\n<div>\r\n<table class=\"aligncenter\" style=\"width: 643px;height: 104px\" border=\"1\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 628.063px\" colspan=\"11\"><strong>Table 11.2.2<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 134.063px\"><strong>Week<\/strong><\/td>\r\n<td style=\"width: 29.0625px\">1<\/td>\r\n<td style=\"width: 35.0625px\">2<\/td>\r\n<td style=\"width: 37.0625px\">3<\/td>\r\n<td style=\"width: 36.0625px\">4<\/td>\r\n<td style=\"width: 36.0625px\">5<\/td>\r\n<td style=\"width: 36.0625px\">6<\/td>\r\n<td style=\"width: 36.0625px\">7<\/td>\r\n<td style=\"width: 35.0625px\">8<\/td>\r\n<td style=\"width: 37.0625px\">9<\/td>\r\n<td style=\"width: 37.0625px\">10<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 134.063px\"><strong>Actual\u00a0<\/strong><strong>Demand<\/strong><\/td>\r\n<td style=\"width: 29.0625px\">800<\/td>\r\n<td style=\"width: 35.0625px\">1400<\/td>\r\n<td style=\"width: 37.0625px\">1000<\/td>\r\n<td style=\"width: 36.0625px\">1500<\/td>\r\n<td style=\"width: 36.0625px\">1500<\/td>\r\n<td style=\"width: 36.0625px\">1300<\/td>\r\n<td style=\"width: 36.0625px\">1800<\/td>\r\n<td style=\"width: 35.0625px\">1700<\/td>\r\n<td style=\"width: 37.0625px\">1300<\/td>\r\n<td style=\"width: 37.0625px\">1700<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 134.063px\"><strong>Forecasted\u00a0<\/strong><strong>demand<\/strong><\/td>\r\n<td style=\"width: 29.0625px\">---<\/td>\r\n<td style=\"width: 35.0625px\">---<\/td>\r\n<td style=\"width: 37.0625px\">---<\/td>\r\n<td style=\"width: 36.0625px\">1067<\/td>\r\n<td style=\"width: 36.0625px\">1300<\/td>\r\n<td style=\"width: 36.0625px\">1333<\/td>\r\n<td style=\"width: 36.0625px\">1433<\/td>\r\n<td style=\"width: 35.0625px\">1533<\/td>\r\n<td style=\"width: 37.0625px\">1600<\/td>\r\n<td style=\"width: 37.0625px\">1600<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n&nbsp;\r\n\r\nForecasted demand for week 11\r\n\r\n&nbsp;\r\n\r\n= Actual demand of (week 8 + week 9 + week 10) \/ 3\r\n\r\n= (1700 + 1300 +1700) \/ 3\r\n\r\n= 1567 units\r\n\r\n&nbsp;\r\n\r\n<strong>Which time period to select: Sensitivity vs. Stability\u00a0<\/strong>\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\">Proper selection of time period is an important aspect of accurate prediction. Different time periods would smoother the fluctuations of past data with random variations in different manner. The longer the moving average period, the more random variables are smoothed which is desirable in most cases. But long time intervals face the danger of missing or ignoring variations which show a particular trend (increasing or decreasing) occurring at small time intervals. Thus, long intervals would provide stable or consistent results whereas short time periods would be more sensitive to abrupt or unexpected variation in the data. For example, daily data collected over a week of a stock to observe its performance may show random variation every day during that week. So, taking into consideration daily data moving average method can be used to predict its performance for first day of next week. But if data is recorded hourly, then certain increasing or decreasing trends can be monitored which were missed in daily data set. Thus, data collected over a short period was more sensitive to certain variation whereas same data recorded over a longer period would be more smooth and stable.<\/p>\r\n&nbsp;\r\n<p style=\"text-align: justify\">Such a scenario has been explained in following illustration.<\/p>\r\n&nbsp;\r\n<p style=\"text-align: justify\"><strong><em>Example 11.2.2: <\/em><\/strong>For following weekly data (shown in Table 11.2.3) forecast demand by using 3 weekly and 9 weekly moving average.<\/p>\r\n\r\n<table class=\"aligncenter\" style=\"height: 185px;width: 692px\" border=\"1\" width=\"675\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 748.063px\" colspan=\"12\"><strong>Table 11.2.3<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 38.0625px\"><strong>Week<\/strong><\/td>\r\n<td style=\"width: 58.0625px\"><strong>Demand<\/strong><\/td>\r\n<td style=\"width: 51.0625px\"><strong>3-<\/strong><strong>week<\/strong><\/td>\r\n<td style=\"width: 51.0625px\"><strong>9-<\/strong><strong>week<\/strong><\/td>\r\n<td style=\"width: 38.0625px\"><strong>Week<\/strong><\/td>\r\n<td style=\"width: 58.0625px\"><strong>Demand<\/strong><\/td>\r\n<td style=\"width: 51.0625px\"><strong>3-<\/strong><strong>week<\/strong><\/td>\r\n<td style=\"width: 51.0625px\"><strong>9-<\/strong><strong>week<\/strong><\/td>\r\n<td style=\"width: 38.0625px\"><strong>Week<\/strong><\/td>\r\n<td style=\"width: 58.0625px\"><strong>Demand<\/strong><\/td>\r\n<td style=\"width: 51.0625px\"><strong>3-<\/strong><strong>week<\/strong><\/td>\r\n<td style=\"width: 51.0625px\"><strong>9-<\/strong><strong>week<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 38.0625px\"><strong><em>1.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">800<\/td>\r\n<td style=\"width: 51.0625px\">---<\/td>\r\n<td style=\"width: 51.0625px\">---<\/td>\r\n<td style=\"width: 38.0625px\"><strong><em>11.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">1,700<\/td>\r\n<td style=\"width: 51.0625px\">1,567<\/td>\r\n<td style=\"width: 51.0625px\">1,467<\/td>\r\n<td style=\"width: 38.0625px\"><strong><em>21.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,400<\/td>\r\n<td style=\"width: 51.0625px\">2,167<\/td>\r\n<td style=\"width: 51.0625px\">2,011<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 38.0625px\"><strong><em>2.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">1,400<\/td>\r\n<td style=\"width: 51.0625px\">---<\/td>\r\n<td style=\"width: 51.0625px\">---<\/td>\r\n<td style=\"width: 38.0625px\"><strong><em>12.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">1,500<\/td>\r\n<td style=\"width: 51.0625px\">1,567<\/td>\r\n<td style=\"width: 51.0625px\">1,500<\/td>\r\n<td style=\"width: 38.0625px\"><strong><em>22.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,600<\/td>\r\n<td style=\"width: 51.0625px\">2,233<\/td>\r\n<td style=\"width: 51.0625px\">2,111<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 38.0625px\"><strong><em>3.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">1,000<\/td>\r\n<td style=\"width: 51.0625px\">---<\/td>\r\n<td style=\"width: 51.0625px\">---<\/td>\r\n<td style=\"width: 38.0625px\"><strong><em>13.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,300<\/td>\r\n<td style=\"width: 51.0625px\">1,633<\/td>\r\n<td style=\"width: 51.0625px\">1,556<\/td>\r\n<td style=\"width: 38.0625px\"><strong><em>23.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,000<\/td>\r\n<td style=\"width: 51.0625px\">2,467<\/td>\r\n<td style=\"width: 51.0625px\">2,144<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 38.0625px\"><strong><em>4<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">1,500<\/td>\r\n<td style=\"width: 51.0625px\">1,067<\/td>\r\n<td style=\"width: 51.0625px\">---<\/td>\r\n<td style=\"width: 38.0625px\"><strong><em>14.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,300<\/td>\r\n<td style=\"width: 51.0625px\">1,833<\/td>\r\n<td style=\"width: 51.0625px\">1,644<\/td>\r\n<td style=\"width: 38.0625px\"><strong><em>24.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,500<\/td>\r\n<td style=\"width: 51.0625px\">2,333<\/td>\r\n<td style=\"width: 51.0625px\">2,111<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 38.0625px\"><strong><em>5.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">1,500<\/td>\r\n<td style=\"width: 51.0625px\">1,300<\/td>\r\n<td style=\"width: 51.0625px\">---<\/td>\r\n<td style=\"width: 38.0625px\"><strong><em>15.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,000<\/td>\r\n<td style=\"width: 51.0625px\">2,033<\/td>\r\n<td style=\"width: 51.0625px\">1,733<\/td>\r\n<td style=\"width: 38.0625px\"><strong><em>25.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,600<\/td>\r\n<td style=\"width: 51.0625px\">2,367<\/td>\r\n<td style=\"width: 51.0625px\">2,167<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n<div>\r\n<table class=\"aligncenter\" style=\"width: 760px;height: 216px\" border=\"1\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 45.0625px\"><strong><em>6.<\/em><\/strong><\/td>\r\n<td style=\"width: 50.0625px\">1,300<\/td>\r\n<td style=\"width: 51.0625px\">1,333<\/td>\r\n<td style=\"width: 46.0625px\">---<\/td>\r\n<td style=\"width: 32.0625px\"><strong><em>16.<\/em><\/strong><\/td>\r\n<td style=\"width: 55.0625px\">1,700<\/td>\r\n<td style=\"width: 55.0625px\">2,200<\/td>\r\n<td style=\"width: 52.0625px\">1,811<\/td>\r\n<td style=\"width: 34.0625px\"><strong><em>26.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,200<\/td>\r\n<td style=\"width: 58.0625px\">2,367<\/td>\r\n<td style=\"width: 55.0625px\">2,267<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 45.0625px\"><strong><em>7.<\/em><\/strong><\/td>\r\n<td style=\"width: 50.0625px\">1,800<\/td>\r\n<td style=\"width: 51.0625px\">1,433<\/td>\r\n<td style=\"width: 46.0625px\">---<\/td>\r\n<td style=\"width: 32.0625px\"><strong><em>17.<\/em><\/strong><\/td>\r\n<td style=\"width: 55.0625px\">1,800<\/td>\r\n<td style=\"width: 55.0625px\">2,000<\/td>\r\n<td style=\"width: 52.0625px\">1,800<\/td>\r\n<td style=\"width: 34.0625px\"><strong><em>27.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,200<\/td>\r\n<td style=\"width: 58.0625px\">2,433<\/td>\r\n<td style=\"width: 55.0625px\">2,311<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 45.0625px\"><strong><em>8.<\/em><\/strong><\/td>\r\n<td style=\"width: 50.0625px\">1,700<\/td>\r\n<td style=\"width: 51.0625px\">1,533<\/td>\r\n<td style=\"width: 46.0625px\">---<\/td>\r\n<td style=\"width: 32.0625px\"><strong><em>18.<\/em><\/strong><\/td>\r\n<td style=\"width: 55.0625px\">2,200<\/td>\r\n<td style=\"width: 55.0625px\">1,833<\/td>\r\n<td style=\"width: 52.0625px\">1,811<\/td>\r\n<td style=\"width: 34.0625px\"><strong><em>28.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,500<\/td>\r\n<td style=\"width: 58.0625px\">2,333<\/td>\r\n<td style=\"width: 55.0625px\">2,311<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 45.0625px\"><strong><em>9.<\/em><\/strong><\/td>\r\n<td style=\"width: 50.0625px\">1,300<\/td>\r\n<td style=\"width: 51.0625px\">1,600<\/td>\r\n<td style=\"width: 46.0625px\">---<\/td>\r\n<td style=\"width: 32.0625px\"><strong><em>19.<\/em><\/strong><\/td>\r\n<td style=\"width: 55.0625px\">1,900<\/td>\r\n<td style=\"width: 55.0625px\">1,900<\/td>\r\n<td style=\"width: 52.0625px\">1,911<\/td>\r\n<td style=\"width: 34.0625px\"><strong><em>29.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,400<\/td>\r\n<td style=\"width: 58.0625px\">2,300<\/td>\r\n<td style=\"width: 55.0625px\">2,378<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 45.0625px\"><strong><em>10.<\/em><\/strong><\/td>\r\n<td style=\"width: 50.0625px\">1,700<\/td>\r\n<td style=\"width: 51.0625px\">1,600<\/td>\r\n<td style=\"width: 46.0625px\">1,367<\/td>\r\n<td style=\"width: 32.0625px\"><strong><em>20.<\/em><\/strong><\/td>\r\n<td style=\"width: 55.0625px\">2,400<\/td>\r\n<td style=\"width: 55.0625px\">1,967<\/td>\r\n<td style=\"width: 52.0625px\">1,933<\/td>\r\n<td style=\"width: 34.0625px\"><strong><em>30.<\/em><\/strong><\/td>\r\n<td style=\"width: 58.0625px\">2,100<\/td>\r\n<td style=\"width: 58.0625px\">2,367<\/td>\r\n<td style=\"width: 55.0625px\">2,378<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 45.0625px\"><strong>Fig. 11.2.1<\/strong><\/td>\r\n<td style=\"width: 50.0625px\"><\/td>\r\n<td style=\"width: 51.0625px\"><\/td>\r\n<td style=\"width: 46.0625px\"><\/td>\r\n<td style=\"width: 32.0625px\"><\/td>\r\n<td style=\"width: 55.0625px\"><\/td>\r\n<td style=\"width: 55.0625px\"><\/td>\r\n<td style=\"width: 52.0625px\"><\/td>\r\n<td style=\"width: 34.0625px\"><\/td>\r\n<td style=\"width: 58.0625px\"><\/td>\r\n<td style=\"width: 58.0625px\"><\/td>\r\n<td style=\"width: 55.0625px\"><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<img class=\"aligncenter size-full wp-image-171\" src=\"http:\/\/mgmtp04.epgpbooks.inflibnet.ac.in\/wp-content\/uploads\/sites\/69\/2018\/10\/10.2.png\" alt=\"\" width=\"405\" height=\"218\" \/>\r\n<p style=\"text-align: justify\">Fig. 11.2.1 shows graphically the effects of various time periods of a moving average. It can be inferred from the graph that by using 9-week period the prediction line is much smoother and thus provides easier way of predicting next periods\u2019 demand. But 3-week moving average line clearly shows that there is sudden and sharp increase in demand after 13th week which falls suddenly after 16th week. Then there is a gradual increase in demand. Also, this line shows that growth level levels off after 23rd week. Thus, 3-week moving average responds in a better manner in following this change than the 9-week average curve. This illustration clearly demonstrates the stability effect of long term and sensitivity effect of short term.<\/p>\r\n&nbsp;\r\n\r\n<strong>11.4 WEIGHTED SIMPLE MOVING AVERAGE\u00a0<\/strong>\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\">The main disadvantage of simple moving average is that the method gives equal weight age to each component of past data. This shortcoming is not too severe when data is collected over a short term period. But if moving average is calculated over a long term period like 60-day period then the problem of data reliability becomes more acute. The importance of data goes on decreasing with passage of time because of changing business conditions. The data which is very old may not be relevant in present scenario so its importance in prediction should be minimal.<\/p>\r\n\r\n<\/div>\r\n<div>\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\">Weighted moving average is useful in solving such discrepancy. In this method oldest data is given least weight age and most recent data the maximum weight age or importance. The sum of weights should not be more than 1. <strong><em>Example 11.3.1: <\/em><\/strong>A manager has collected sales data for last four weeks and would like to predict sales for next coming week by considering weight age to first week as least important and for recent week as most important. (Table 11.3.1)<\/p>\r\n\r\n<table class=\"aligncenter\" style=\"width: 300px\" border=\"1\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 135.063px\" colspan=\"5\"><strong>Table 11.3.1<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 135.063px\"><strong>Week<\/strong><\/td>\r\n<td style=\"width: 55.0625px\"><strong><em>1.<\/em><\/strong><\/td>\r\n<td style=\"width: 47.0625px\"><strong><em>2.<\/em><\/strong><\/td>\r\n<td style=\"width: 53.0625px\"><strong><em>3.<\/em><\/strong><\/td>\r\n<td style=\"width: 48.0625px\"><strong><em>4.<\/em><\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 135.063px\"><strong>Sales<\/strong><\/td>\r\n<td style=\"width: 55.0625px\">100<\/td>\r\n<td style=\"width: 47.0625px\">90<\/td>\r\n<td style=\"width: 53.0625px\">105<\/td>\r\n<td style=\"width: 48.0625px\">95<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 135.063px\"><strong>Weight age (%)<\/strong><\/td>\r\n<td style=\"width: 55.0625px\">10<\/td>\r\n<td style=\"width: 47.0625px\">20<\/td>\r\n<td style=\"width: 53.0625px\">30<\/td>\r\n<td style=\"width: 48.0625px\">40<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n&nbsp;\r\n\r\nForecast for 5th week\r\n\r\n&nbsp;\r\n\r\n= 0.10*100 + 0.20*90 + 0.30*105 + 0.40*95\r\n\r\n= 97.5 units.\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\">Selection of weights is prerogative of the manager by taking into consideration a simple fact: that most recent data is most accurate way of predicting next period and most past data is least reliable way of doing the same.<\/p>\r\n&nbsp;\r\n\r\n<strong>11.5 EXPONENTIAL SMOOTHING\u00a0<\/strong>\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\">Exponential Smoothing is another method used for prediction of data which varies over a short term period of less than six months and does not follow any regular pattern. In previous two methods, using method of moving averages, the process of calculating averages becomes tedious if data is huge and time periods selected is also large. Exponential smoothing formula, as would be discussed below, requires only immediate three data values, namely, forecast and actual demand of immediate previous period and a smoothing coefficient.<\/p>\r\n&nbsp;\r\n\r\nThis method uses following formula for predicting demand or any other data:\r\n\r\nFt+1 = \u03b1Dt + (1- \u03b1)Ft\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ....(1)\r\n\r\nWhere: Ft+1 = forecast for the estimated period\r\n\r\nDt = actual demand for immediate previous period\r\n\r\nFt = forecasted demand for immediate previous period \u03b1 = smoothing coefficient\r\n\r\n&nbsp;\r\n\r\n<strong>Selection of smoothing coefficient \u2018\u03b1\u2019:\u00a0<\/strong>\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\">The selection of a proper smoothing coefficient value can be determined by following two methods:<\/p>\r\n&nbsp;\r\n<p style=\"text-align: justify\">1. An \u2018\u03b1\u2019 value that results in least amount of forecasting error is considered to provide more accurate forecasting results. Forecast error is defined as the difference between forecasted and actual demand. Methods of calculating forecasting errors and their application in deciding proper \u2018\u03b1\u2019 would be discussed in next module.<\/p>\r\n\r\n<\/div>\r\n<div>\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\">2. Another way of determining a proper \u2018\u03b1\u2019 value is its role in smoothing an irregular data. As has been discussed this method along with method of averages, accurate forecasting depend on how data gets smoothed by using law of averages.\u00a0 Such\u00a0 methodology is adopted because\u00a0 of\u00a0 random or\u00a0 unknown pattern of variation in the data. In exponential smoothing method the random data is smoothen out by using a smoothing coefficient denoted by \u03b1. The value of this smoothing coefficient varies from 0 to 1. The formula as shown in equation (1) indicates multiplication of \u2018\u03b1\u2019 with actual demand of previous period and its opposite i.e. (1 \u2013 \u03b1) with forecasted demand of previous period. This implies that a manger would tend to use higher value of smoothing coefficient (such as 0.7, 0.8 etc.) if data of actual demand is considered more important than forecasted demand. In such a case actual demand would contribute more in estimation of next periods\u2019 demand. This can also be interpreted as, that higher value of smoothing coefficient suggests less accurate or reliable forecast for the previous period so a manager tends to give more importance to actual demand data. Similarly, a lower value of \u2018\u03b1\u2019 (such as 0.3, 0.4...etc.) would imply more accurate forecasted data whose contribution in estimating next periods\u2019 data would be more as compared to actual demand data. This has been illustrated by using following example.<\/p>\r\n&nbsp;\r\n<p style=\"text-align: justify\"><strong><em>Example 11.4.1: <\/em><\/strong>By using smoothing coefficient \u03b1 as 0.3 and 0.7 forecast for the following time series data (table 11.4.1) by considering actual demand of week 1 as forecast demand for week 2.<\/p>\r\n\r\n<table class=\"aligncenter\" style=\"width: 375px\" border=\"1\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 72.0625px\" colspan=\"11\"><strong>Table 11.4.1<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 72.0625px\"><strong>Time (in<\/strong>\r\n\r\n<strong>weeks)<\/strong><\/td>\r\n<td style=\"width: 29.0625px\">&nbsp;\r\n\r\n1<\/td>\r\n<td style=\"width: 32.0625px\">&nbsp;\r\n\r\n2<\/td>\r\n<td style=\"width: 31.0625px\">&nbsp;\r\n\r\n3<\/td>\r\n<td style=\"width: 28.0625px\">&nbsp;\r\n\r\n4<\/td>\r\n<td style=\"width: 31.0625px\">&nbsp;\r\n\r\n5<\/td>\r\n<td style=\"width: 29.0625px\">&nbsp;\r\n\r\n6<\/td>\r\n<td style=\"width: 32.0625px\">&nbsp;\r\n\r\n7<\/td>\r\n<td style=\"width: 31.0625px\">&nbsp;\r\n\r\n8<\/td>\r\n<td style=\"width: 31.0625px\">&nbsp;\r\n\r\n9<\/td>\r\n<td style=\"width: 29.0625px\">&nbsp;\r\n\r\n10<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 72.0625px\"><strong>Actual<\/strong>\r\n\r\n<strong>Demand<\/strong><\/td>\r\n<td style=\"width: 29.0625px\">&nbsp;\r\n\r\n27<\/td>\r\n<td style=\"width: 32.0625px\">&nbsp;\r\n\r\n30<\/td>\r\n<td style=\"width: 31.0625px\">&nbsp;\r\n\r\n32<\/td>\r\n<td style=\"width: 28.0625px\">&nbsp;\r\n\r\n31<\/td>\r\n<td style=\"width: 31.0625px\">&nbsp;\r\n\r\n28<\/td>\r\n<td style=\"width: 29.0625px\">&nbsp;\r\n\r\n27<\/td>\r\n<td style=\"width: 32.0625px\">&nbsp;\r\n\r\n30<\/td>\r\n<td style=\"width: 31.0625px\">&nbsp;\r\n\r\n33<\/td>\r\n<td style=\"width: 31.0625px\">&nbsp;\r\n\r\n33<\/td>\r\n<td style=\"width: 29.0625px\">&nbsp;\r\n\r\n31<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n&nbsp;\r\n\r\nExponential Smoothing uses following formula:\r\n\r\nFt+1 = \u03b1Dt + (1- \u03b1)Ft\r\n\r\nBy using \u03b1 = 0.3 forecast for week 2 would be\r\n<table style=\"width: 392px\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 108px\"><\/td>\r\n<td style=\"width: 140px\">F2<\/td>\r\n<td style=\"width: 144px\">= \u03b1D1 + (1 \u2013 \u03b1 )F1<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108px\"><\/td>\r\n<td style=\"width: 140px\"><\/td>\r\n<td style=\"width: 144px\">= 0.3*27 + 0.7*27<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108px\"><\/td>\r\n<td style=\"width: 140px\"><\/td>\r\n<td style=\"width: 144px\">= 27<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108px\">Similarly for<\/td>\r\n<td style=\"width: 140px\">F3<\/td>\r\n<td style=\"width: 144px\">= \u03b1D2 + (1 \u2013 \u03b1)F2<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108px\"><\/td>\r\n<td style=\"width: 140px\"><\/td>\r\n<td style=\"width: 144px\">= 0.3*30 + 0.7*27<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108px\"><\/td>\r\n<td style=\"width: 140px\"><\/td>\r\n<td style=\"width: 144px\">= 27.9<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<p style=\"text-align: justify\">Forecast for other weeks can be calculated in similar fashion. Table 11.4.2 shows final results with forecasted demand with both \u03b1= 0.3 and \u03b1 =0.7.<\/p>\r\n\r\n<\/div>\r\n<div>\r\n<table class=\"aligncenter\" style=\"width: 597px\" border=\"1\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 108.063px\" colspan=\"4\"><strong>Table 11.4.2<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\"><strong>Time (in weeks)<\/strong><\/td>\r\n<td style=\"width: 111.063px\"><strong>Actual Demand<\/strong><\/td>\r\n<td style=\"width: 161.063px\"><strong>Forecast demand (\u03b1= 0.3)<\/strong><\/td>\r\n<td style=\"width: 160.063px\"><strong>Forecast demand (\u03b1= 0.7)<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\">1.<\/td>\r\n<td style=\"width: 111.063px\">27<\/td>\r\n<td style=\"width: 161.063px\">-----<\/td>\r\n<td style=\"width: 160.063px\">-----<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\">2.<\/td>\r\n<td style=\"width: 111.063px\">30<\/td>\r\n<td style=\"width: 161.063px\">27<\/td>\r\n<td style=\"width: 160.063px\">27<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\">3.<\/td>\r\n<td style=\"width: 111.063px\">32<\/td>\r\n<td style=\"width: 161.063px\">27.9<\/td>\r\n<td style=\"width: 160.063px\">29.1<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\">4.<\/td>\r\n<td style=\"width: 111.063px\">31<\/td>\r\n<td style=\"width: 161.063px\">29.13<\/td>\r\n<td style=\"width: 160.063px\">31.13<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\">5.<\/td>\r\n<td style=\"width: 111.063px\">28<\/td>\r\n<td style=\"width: 161.063px\">29.69<\/td>\r\n<td style=\"width: 160.063px\">31.03<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\">6.<\/td>\r\n<td style=\"width: 111.063px\">27<\/td>\r\n<td style=\"width: 161.063px\">29.18<\/td>\r\n<td style=\"width: 160.063px\">28.91<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\">7.<\/td>\r\n<td style=\"width: 111.063px\">30<\/td>\r\n<td style=\"width: 161.063px\">28.52<\/td>\r\n<td style=\"width: 160.063px\">27.57<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\">8.<\/td>\r\n<td style=\"width: 111.063px\">33<\/td>\r\n<td style=\"width: 161.063px\">28.97<\/td>\r\n<td style=\"width: 160.063px\">29.27<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\">9.<\/td>\r\n<td style=\"width: 111.063px\">31<\/td>\r\n<td style=\"width: 161.063px\">30.17<\/td>\r\n<td style=\"width: 160.063px\">31.88<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\">10.<\/td>\r\n<td style=\"width: 111.063px\">31<\/td>\r\n<td style=\"width: 161.063px\">30.42<\/td>\r\n<td style=\"width: 160.063px\">31.26<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 108.063px\"><strong>Fig. 11.4.1<\/strong><\/td>\r\n<td style=\"width: 111.063px\"><\/td>\r\n<td style=\"width: 161.063px\"><\/td>\r\n<td style=\"width: 160.063px\"><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<img class=\"aligncenter size-full wp-image-172\" src=\"http:\/\/mgmtp04.epgpbooks.inflibnet.ac.in\/wp-content\/uploads\/sites\/69\/2018\/10\/11.2.png\" alt=\"\" width=\"471\" height=\"187\" \/>\r\n<p style=\"text-align: justify\">Fig. 11.4.1 clearly shows that with \u03b1 = 0.3 provides more smoothing effect to random demand data than with \u03b1 = 0.7. From this it can be inferred that forecasting done for week 11 would be more accurate by using \u03b1 = 0.3. Forecast for week 11\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 0.3*31 + 0.7*30.42<\/p>\r\n<p style=\"padding-left: 240px\">= 30.59<\/p>\r\n&nbsp;\r\n\r\n&nbsp;\r\n\r\n<strong>11.6 SUMMARY\u00a0<\/strong>\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\">This chapter discusses methods of forecasting when demand or any other data set varies over a short term period. It has been emphasized that during such short term period it is difficult to assign a pattern to demand fluctuation. Thus, methods such as simple moving average, weighted moving average and exponential smoothing\u00a0<span style=\"font-size: 1em;text-align: initial\">which have been discussed with illustrations are applied when fluctuation in data is random and unknown. Simple moving average gives equal importance to every data value. But with passage of time old data has less relevance to present conditions. Thus, its importance decreases. So, weighted moving average was devised to give different weights to different data values depending on their occurrence in time series. Oldest data was given least importance and recent data the maximum. These two methods faced with another problem. In both the methods a manager has to carry all of data to predict for future time periods. In big data sets this becomes quite a tedious task. Exponential smoothing method helps to resolve this problem to a great extent.<\/span><\/p>\r\n\r\n<\/div>\r\n<div>\r\n\r\n&nbsp;\r\n\r\n<strong>11.7 GLOSSARY\u00a0<\/strong>\r\n<ul>\r\n \t<li style=\"text-align: justify\"><strong><em>Time Series analysis: <\/em><\/strong>A type of forecast in which data relating to past demand are used to predict future demand.<\/li>\r\n \t<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Simple Moving Average: <\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">A forecasting technique in which every pat data value is given equal weight age.<\/span><\/li>\r\n \t<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Weighted Moving Average: <\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">A forecasting technique in which older data is given less importance than recent data.<\/span><\/li>\r\n \t<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Exponential \u00a0Smoothing: \u00a0<\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">A \u00a0forecasting \u00a0technique \u00a0in \u00a0which \u00a0each \u00a0increment \u00a0of \u00a0past \u00a0demand \u00a0data \u00a0is decreased by (1 \u2013 \u03b1).<\/span><\/li>\r\n<\/ul>\r\n&nbsp;\r\n\r\n<strong>11.8 REFERENCES\/ SUGGESTED READINGS\u00a0<\/strong>\r\n<ul>\r\n \t<li style=\"text-align: justify\">Chase, B.R., Shankar, R., Jacobs, F.R. and Aquilano, N.J., <em>Operations &amp; Supply Chain Management, <\/em>12th Edition, McGraw Hill.<\/li>\r\n \t<li style=\"text-align: justify\">Stevenson, W.J., <em style=\"text-align: initial;font-size: 1em\">Operations Management, <\/em><span style=\"text-align: initial;font-size: 1em\">9th Edition, Tata McGraw Hill.<\/span><\/li>\r\n \t<li style=\"text-align: justify\">Lee J. Krajewski, <em style=\"text-align: initial;font-size: 1em\">Operations Management, <\/em><span style=\"text-align: initial;font-size: 1em\">Prentice-Hall of India, New Delhi, 8th Edition.<\/span><\/li>\r\n<\/ul>\r\n&nbsp;\r\n\r\n<strong>11.9 Short Answer Questions\u00a0<\/strong>\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\"><strong>1.\u00a0<\/strong>Which of the following is true concerning the smoothing parameter (\u03b1) used in exponential smoothing?<\/p>\r\n&nbsp;\r\n\r\na. \u03b1 = 0.4 means the forecast for the next period is based on 40% older data and 60% recent data.\r\n\r\nb. If \u03b1 = 0, the forecast is equivalent to the naive forecast.\r\n\r\nc. The higher the value of \u03b1, the less the effect of smoothing.\r\n\r\nd. All of the above.\r\n\r\n&nbsp;\r\n\r\nAnswer: d\r\n\r\n&nbsp;\r\n<p style=\"text-align: justify\"><strong>2.\u00a0<\/strong>Which of the following forecasting method is not used for short term period forecast?<\/p>\r\n&nbsp;\r\n\r\na.\u00a0 Seasonal Method\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0b. Simple Moving Average\r\n\r\n&nbsp;\r\n\r\nc. Weighted Moving Average\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 d. Exponential Smoothing\r\n\r\n<\/div>\r\n&nbsp;\r\n\r\nAnswer: a\r\n<ol start=\"3\">\r\n \t<li style=\"text-align: justify\">Exponential smoothing only includes the most recent demand and ignores earlier demands, so simple moving average is better.\r\n<ol>\r\n \t<li>True b. False<\/li>\r\n<\/ol>\r\n<\/li>\r\n<\/ol>\r\n&nbsp;\r\n\r\nAnswer: b\r\n<ol start=\"4\">\r\n \t<li style=\"text-align: justify\">Data forecasted by using short term periods are whereas those forecasted with longer time intervals are more\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _.<\/li>\r\n<\/ol>\r\n<p style=\"padding-left: 30px\">Answer: sensitive, stable<\/p>\r\n&nbsp;\r\n\r\n<strong>11.10 Model Questions<\/strong>\r\n<ol>\r\n \t<li style=\"text-align: justify\">What advantages does exponential smoothing method of forecasting have over moving averages?<\/li>\r\n \t<li style=\"text-align: justify\">How does the number of periods in a moving average affect the responsiveness of the forecast?<\/li>\r\n \t<li style=\"text-align: justify\">What factors are considered in the choice of exponential smoothing coefficient?<\/li>\r\n \t<li style=\"text-align: justify\">For the following data make a forecast for this week on the following basis:<\/li>\r\n<\/ol>\r\n<ul>\r\n \t<li style=\"text-align: justify\">(a) Daily using a simple four-week moving av<\/li>\r\n \t<li style=\"text-align: justify\">(b) Daily, using a weighted average of 0.40, 0.30, 0.20 and 0.10 for past four week<\/li>\r\n \t<li style=\"text-align: justify\">(c) Daily, by using smoothing coefficient of 10% for this we Take last weeks\u2019 Saturday demand as initial demand for this week\u2019s Monday.<\/li>\r\n<\/ul>\r\n<table class=\"aligncenter\" border=\"1\">\r\n<tbody>\r\n<tr>\r\n<td><\/td>\r\n<td><strong>4 Weeks Ago<\/strong><\/td>\r\n<td><strong>3 Weeks Ago<\/strong><\/td>\r\n<td><strong>2 Weeks Ago<\/strong><\/td>\r\n<td><strong>Last Week<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>Monday<\/strong><\/td>\r\n<td>2,200<\/td>\r\n<td>2,400<\/td>\r\n<td>2,300<\/td>\r\n<td>2,400<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>Tuesday<\/strong><\/td>\r\n<td>2,000<\/td>\r\n<td>2,100<\/td>\r\n<td>2,200<\/td>\r\n<td>2,200<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>We<\/strong><strong>dnesday<\/strong><\/td>\r\n<td>2,300<\/td>\r\n<td>2,400<\/td>\r\n<td>2,300<\/td>\r\n<td>2,500<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>Thursday<\/strong><\/td>\r\n<td>1,800<\/td>\r\n<td>1,900<\/td>\r\n<td>1,800<\/td>\r\n<td>2,000<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>Friday<\/strong><\/td>\r\n<td>1,900<\/td>\r\n<td>1,800<\/td>\r\n<td>2,100<\/td>\r\n<td>2,000<\/td>\r\n<\/tr>\r\n<tr>\r\n<td><strong>Saturday<\/strong><\/td>\r\n<td>2800<\/td>\r\n<td>2700<\/td>\r\n<td>3000<\/td>\r\n<td>2900<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n&nbsp;","rendered":"<div><\/div>\n<div>\n<p>&nbsp;<\/p>\n<p><strong>11.1 <\/strong><strong>OBJECTIVES<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>This chapter would help students to understand:<\/p>\n<ul>\n<li>Importance of time period in fluctuation of data<\/li>\n<li>Role of variation of data in selecting a particular forecasting technique<\/li>\n<li>Methods of forecasting when variation in demand is random: Simple Moving Average, Weighted Moving Average, Exponential Smoothing<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>11.2 INTRODUCTION\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">Time series models of forecasting require past data to fulfill objective of prediction. This type of data is recorded over a period of time\u00a0 taken at regular intervals (e.g. hourly, weekly, monthly, annually).\u00a0 The\u00a0 data collected over a selected time period can be regarding sales of a product, absenteeism rate, operating time on a machine, profits etc. For example, sales figures collected over a period of four weeks can be used to predict sales of fifth week.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">The most important aspect to understand is the time interval for which data has to be collected. Should a particular data be collected hourly,\u00a0 daily, weekly, monthly or\u00a0 at\u00a0 any other\u00a0 rate? Data\u00a0 fluctuation\u00a0 is directly proportional to time interval selected. It can show a trend, seasonal, cyclical or random variation. The fluctuation behavior of data would be instrumental in\u00a0 deciding proper forecasting technique.\u00a0 Time intervals\u00a0 are\u00a0 always discussed in relative sense. Terms such as short, medium and long term are relative to the context in which they\u00a0<span style=\"text-align: initial;font-size: 1em\">are used. Table 11.1.1 shows type of forecasting technique some of which would be discussed in this chapter in context of time period. Short term period is referred as data collected over a time period of less than 3 months; medium term: three months to two years and long term as more than two years.<\/span><\/p>\n<\/div>\n<div>\n<table class=\"aligncenter\" style=\"width: 682px;height: 282px\">\n<tbody>\n<tr>\n<td style=\"width: 667.063px\" colspan=\"3\"><strong>Table 11.1.1<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 118.063px\"><strong>Time period<\/strong><\/td>\n<td style=\"width: 235.063px\"><strong>Data pattern<\/strong><\/td>\n<td style=\"width: 286.063px\"><strong>Forecasting technique<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 118.063px\">Short term: less than 3 months<\/td>\n<td style=\"width: 235.063px\">Data \u00a0does \u00a0not \u00a0show \u00a0any \u00a0particular pattern \u00a0or variation.<\/td>\n<td style=\"width: 286.063px\">\n<ul>\n<li>Simple Moving Average,<\/li>\n<li>Weighted \u00a0moving \u00a0average and<\/li>\n<li>Exponential Smoothing<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 118.063px\">Medium term: 3 months to two years<\/td>\n<td style=\"width: 235.063px\">Data either repeats periodically or move along a particular direction i.e. upward or downward<\/td>\n<td style=\"width: 286.063px\">\n<ul>\n<li>Seasonal and Trend Variation<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 118.063px\">Long term: more than 2 years<\/td>\n<td style=\"width: 235.063px\">Data \u00a0shows \u00a0repeated \u00a0pattern \u00a0but \u00a0at irregular intervals with irregular intensity<\/td>\n<td style=\"width: 286.063px\">\n<ul>\n<li>Cyclical method<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">Also selected time period has an influence over accuracy of prediction. If the data is collected for a very long term period it might provide\u00a0 good\u00a0 results\u00a0 but\u00a0 older\u00a0 data may not have relevance\u00a0 in\u00a0 present\u00a0 scenario. Likewise, if only recent data is used it might not be sufficient to give reliable prediction results. Thus, time period and availability of data over that time period influences accuracy of forecasting.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">In previous modules we have discussed four ways in which data can fluctuate. These methods have been briefed here with some illustrations.<\/p>\n<ul>\n<li style=\"text-align: justify\"><strong><em>Seasonal: <\/em><\/strong>Amount of traffic increases twice every day and shows similar pattern next working day. So, data regarding traffic will show a repetitive cycle with equal time intervals.<\/li>\n<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Cyclical: <\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">Fashion keeps on changing with one style of clothing which had gone out of fashion would again be considered in vogue. But this happens at irregular time intervals where it is very difficult to predict when one style will go out of fashion and when it will reappear.<\/span><\/li>\n<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Trend: <\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">A mobile phone company might see an upward trend of sale of their smart phones over last six- eight months but with competitor launching a new variant the company\u2019s sale might start to slow down weekly. So, the sale of smart phones showed an increasing trend over monthly data whereas decrease in sale of smart phones showed a decreasing trend over weekly data.<\/span><\/li>\n<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Random: <\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">Fluctuation of a share in stock market shows an irregular trend and its fluctuation is recorded hourly or even at smaller time period.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">Thus, which forecasting model a firm should select, depends on:<\/p>\n<\/div>\n<div>\n<ul>\n<li>Time horizon to forecast<\/li>\n<li>Availability of data<\/li>\n<li>Accuracy required<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">Taking these aspects into consideration following section discusses three forecasting techniques in context of random variation of data. These methods are:<\/p>\n<ul>\n<li>Simple Moving Average<\/li>\n<li>Weighted Moving Average<\/li>\n<li>Exponential Smoothing<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>11.3 SIMPLE MOVING AVERAGE\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">A data is considered to follow random fluctuations if it is neither increasing nor decreasing over a short term period and also does not shown any seasonal pattern over medium term. The absence of pattern in the data is reflected when it is recorded with short time intervals such as hourly, daily or weekly. The method is called as moving average because forecasted data keeps moving from one time period to another. For instance, suppose we have data for last 12 weeks and we need to forecast for 6th week by taking past data of five weeks. This can be done by averaging actual data of first five weeks and calculating its simple average. Similarly forecast for 7th week would require data of past five weeks i.e. from 2nd to 6th week and in same fashion data keeps on moving by leaving the earliest week and adding the most recent week data.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">This has been illustrated by following example:<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\"><strong><em>Example 11.2.1: <\/em><\/strong>For the following weekly demand for 10 weeks (as shown in Table 11.2.1) predict demand from 4th week to 11th week by using past 3 weekly data.<\/p>\n<table class=\"aligncenter\" style=\"width: 526px\">\n<tbody>\n<tr>\n<td style=\"width: 72.0625px\" colspan=\"11\"><strong>Table 11.2.1<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 72.0625px\"><strong>Week<\/strong><\/td>\n<td style=\"width: 41.0625px\">1<\/td>\n<td style=\"width: 46.0625px\">2<\/td>\n<td style=\"width: 47.0625px\">3<\/td>\n<td style=\"width: 46.0625px\">4<\/td>\n<td style=\"width: 46.0625px\">5<\/td>\n<td style=\"width: 46.0625px\">6<\/td>\n<td style=\"width: 46.0625px\">7<\/td>\n<td style=\"width: 45.0625px\">8<\/td>\n<td style=\"width: 46.0625px\">9<\/td>\n<td style=\"width: 45.0625px\">10<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 72.0625px\"><strong>Actual\u00a0<\/strong><strong>Demand<\/strong><\/td>\n<td style=\"width: 41.0625px\">800<\/td>\n<td style=\"width: 46.0625px\">1400<\/td>\n<td style=\"width: 47.0625px\">1000<\/td>\n<td style=\"width: 46.0625px\">1500<\/td>\n<td style=\"width: 46.0625px\">1500<\/td>\n<td style=\"width: 46.0625px\">1300<\/td>\n<td style=\"width: 46.0625px\">1800<\/td>\n<td style=\"width: 45.0625px\">1700<\/td>\n<td style=\"width: 46.0625px\">1300<\/td>\n<td style=\"width: 45.0625px\">1700<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">To predict for 4th week by taking past data calculate simple average of actual demand of week 1, week 2 and week<\/p>\n<p>&nbsp;<\/p>\n<p>Average (4th week)<\/p>\n<p>&nbsp;<\/p>\n<p>= Actual demand of (week 1 + week 2 + week 3) \/ 3<\/p>\n<p>= (800 + 1400 + 1000)\/3<\/p>\n<p>= 1067 units<\/p>\n<p>&nbsp;<\/p>\n<p>Average (5th week)<\/p>\n<p>&nbsp;<\/p>\n<p>= Actual demand of (week 2 + week 3 + week 4) \/ 3<\/p>\n<p>= (1400 + 1000 + 1500)\/3<\/p>\n<p>= 1300 units<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">Similarly forecasted demand can be calculated for each week as shown in Table 11.3.2<\/p>\n<\/div>\n<div>\n<table class=\"aligncenter\" style=\"width: 643px;height: 104px\">\n<tbody>\n<tr>\n<td style=\"width: 628.063px\" colspan=\"11\"><strong>Table 11.2.2<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 134.063px\"><strong>Week<\/strong><\/td>\n<td style=\"width: 29.0625px\">1<\/td>\n<td style=\"width: 35.0625px\">2<\/td>\n<td style=\"width: 37.0625px\">3<\/td>\n<td style=\"width: 36.0625px\">4<\/td>\n<td style=\"width: 36.0625px\">5<\/td>\n<td style=\"width: 36.0625px\">6<\/td>\n<td style=\"width: 36.0625px\">7<\/td>\n<td style=\"width: 35.0625px\">8<\/td>\n<td style=\"width: 37.0625px\">9<\/td>\n<td style=\"width: 37.0625px\">10<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 134.063px\"><strong>Actual\u00a0<\/strong><strong>Demand<\/strong><\/td>\n<td style=\"width: 29.0625px\">800<\/td>\n<td style=\"width: 35.0625px\">1400<\/td>\n<td style=\"width: 37.0625px\">1000<\/td>\n<td style=\"width: 36.0625px\">1500<\/td>\n<td style=\"width: 36.0625px\">1500<\/td>\n<td style=\"width: 36.0625px\">1300<\/td>\n<td style=\"width: 36.0625px\">1800<\/td>\n<td style=\"width: 35.0625px\">1700<\/td>\n<td style=\"width: 37.0625px\">1300<\/td>\n<td style=\"width: 37.0625px\">1700<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 134.063px\"><strong>Forecasted\u00a0<\/strong><strong>demand<\/strong><\/td>\n<td style=\"width: 29.0625px\">&#8212;<\/td>\n<td style=\"width: 35.0625px\">&#8212;<\/td>\n<td style=\"width: 37.0625px\">&#8212;<\/td>\n<td style=\"width: 36.0625px\">1067<\/td>\n<td style=\"width: 36.0625px\">1300<\/td>\n<td style=\"width: 36.0625px\">1333<\/td>\n<td style=\"width: 36.0625px\">1433<\/td>\n<td style=\"width: 35.0625px\">1533<\/td>\n<td style=\"width: 37.0625px\">1600<\/td>\n<td style=\"width: 37.0625px\">1600<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Forecasted demand for week 11<\/p>\n<p>&nbsp;<\/p>\n<p>= Actual demand of (week 8 + week 9 + week 10) \/ 3<\/p>\n<p>= (1700 + 1300 +1700) \/ 3<\/p>\n<p>= 1567 units<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Which time period to select: Sensitivity vs. Stability\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">Proper selection of time period is an important aspect of accurate prediction. Different time periods would smoother the fluctuations of past data with random variations in different manner. The longer the moving average period, the more random variables are smoothed which is desirable in most cases. But long time intervals face the danger of missing or ignoring variations which show a particular trend (increasing or decreasing) occurring at small time intervals. Thus, long intervals would provide stable or consistent results whereas short time periods would be more sensitive to abrupt or unexpected variation in the data. For example, daily data collected over a week of a stock to observe its performance may show random variation every day during that week. So, taking into consideration daily data moving average method can be used to predict its performance for first day of next week. But if data is recorded hourly, then certain increasing or decreasing trends can be monitored which were missed in daily data set. Thus, data collected over a short period was more sensitive to certain variation whereas same data recorded over a longer period would be more smooth and stable.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">Such a scenario has been explained in following illustration.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\"><strong><em>Example 11.2.2: <\/em><\/strong>For following weekly data (shown in Table 11.2.3) forecast demand by using 3 weekly and 9 weekly moving average.<\/p>\n<table class=\"aligncenter\" style=\"height: 185px;width: 692px; width: 675px;\">\n<tbody>\n<tr>\n<td style=\"width: 748.063px\" colspan=\"12\"><strong>Table 11.2.3<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 38.0625px\"><strong>Week<\/strong><\/td>\n<td style=\"width: 58.0625px\"><strong>Demand<\/strong><\/td>\n<td style=\"width: 51.0625px\"><strong>3-<\/strong><strong>week<\/strong><\/td>\n<td style=\"width: 51.0625px\"><strong>9-<\/strong><strong>week<\/strong><\/td>\n<td style=\"width: 38.0625px\"><strong>Week<\/strong><\/td>\n<td style=\"width: 58.0625px\"><strong>Demand<\/strong><\/td>\n<td style=\"width: 51.0625px\"><strong>3-<\/strong><strong>week<\/strong><\/td>\n<td style=\"width: 51.0625px\"><strong>9-<\/strong><strong>week<\/strong><\/td>\n<td style=\"width: 38.0625px\"><strong>Week<\/strong><\/td>\n<td style=\"width: 58.0625px\"><strong>Demand<\/strong><\/td>\n<td style=\"width: 51.0625px\"><strong>3-<\/strong><strong>week<\/strong><\/td>\n<td style=\"width: 51.0625px\"><strong>9-<\/strong><strong>week<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 38.0625px\"><strong><em>1.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">800<\/td>\n<td style=\"width: 51.0625px\">&#8212;<\/td>\n<td style=\"width: 51.0625px\">&#8212;<\/td>\n<td style=\"width: 38.0625px\"><strong><em>11.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">1,700<\/td>\n<td style=\"width: 51.0625px\">1,567<\/td>\n<td style=\"width: 51.0625px\">1,467<\/td>\n<td style=\"width: 38.0625px\"><strong><em>21.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,400<\/td>\n<td style=\"width: 51.0625px\">2,167<\/td>\n<td style=\"width: 51.0625px\">2,011<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 38.0625px\"><strong><em>2.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">1,400<\/td>\n<td style=\"width: 51.0625px\">&#8212;<\/td>\n<td style=\"width: 51.0625px\">&#8212;<\/td>\n<td style=\"width: 38.0625px\"><strong><em>12.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">1,500<\/td>\n<td style=\"width: 51.0625px\">1,567<\/td>\n<td style=\"width: 51.0625px\">1,500<\/td>\n<td style=\"width: 38.0625px\"><strong><em>22.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,600<\/td>\n<td style=\"width: 51.0625px\">2,233<\/td>\n<td style=\"width: 51.0625px\">2,111<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 38.0625px\"><strong><em>3.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">1,000<\/td>\n<td style=\"width: 51.0625px\">&#8212;<\/td>\n<td style=\"width: 51.0625px\">&#8212;<\/td>\n<td style=\"width: 38.0625px\"><strong><em>13.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,300<\/td>\n<td style=\"width: 51.0625px\">1,633<\/td>\n<td style=\"width: 51.0625px\">1,556<\/td>\n<td style=\"width: 38.0625px\"><strong><em>23.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,000<\/td>\n<td style=\"width: 51.0625px\">2,467<\/td>\n<td style=\"width: 51.0625px\">2,144<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 38.0625px\"><strong><em>4<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">1,500<\/td>\n<td style=\"width: 51.0625px\">1,067<\/td>\n<td style=\"width: 51.0625px\">&#8212;<\/td>\n<td style=\"width: 38.0625px\"><strong><em>14.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,300<\/td>\n<td style=\"width: 51.0625px\">1,833<\/td>\n<td style=\"width: 51.0625px\">1,644<\/td>\n<td style=\"width: 38.0625px\"><strong><em>24.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,500<\/td>\n<td style=\"width: 51.0625px\">2,333<\/td>\n<td style=\"width: 51.0625px\">2,111<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 38.0625px\"><strong><em>5.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">1,500<\/td>\n<td style=\"width: 51.0625px\">1,300<\/td>\n<td style=\"width: 51.0625px\">&#8212;<\/td>\n<td style=\"width: 38.0625px\"><strong><em>15.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,000<\/td>\n<td style=\"width: 51.0625px\">2,033<\/td>\n<td style=\"width: 51.0625px\">1,733<\/td>\n<td style=\"width: 38.0625px\"><strong><em>25.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,600<\/td>\n<td style=\"width: 51.0625px\">2,367<\/td>\n<td style=\"width: 51.0625px\">2,167<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table class=\"aligncenter\" style=\"width: 760px;height: 216px\">\n<tbody>\n<tr>\n<td style=\"width: 45.0625px\"><strong><em>6.<\/em><\/strong><\/td>\n<td style=\"width: 50.0625px\">1,300<\/td>\n<td style=\"width: 51.0625px\">1,333<\/td>\n<td style=\"width: 46.0625px\">&#8212;<\/td>\n<td style=\"width: 32.0625px\"><strong><em>16.<\/em><\/strong><\/td>\n<td style=\"width: 55.0625px\">1,700<\/td>\n<td style=\"width: 55.0625px\">2,200<\/td>\n<td style=\"width: 52.0625px\">1,811<\/td>\n<td style=\"width: 34.0625px\"><strong><em>26.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,200<\/td>\n<td style=\"width: 58.0625px\">2,367<\/td>\n<td style=\"width: 55.0625px\">2,267<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 45.0625px\"><strong><em>7.<\/em><\/strong><\/td>\n<td style=\"width: 50.0625px\">1,800<\/td>\n<td style=\"width: 51.0625px\">1,433<\/td>\n<td style=\"width: 46.0625px\">&#8212;<\/td>\n<td style=\"width: 32.0625px\"><strong><em>17.<\/em><\/strong><\/td>\n<td style=\"width: 55.0625px\">1,800<\/td>\n<td style=\"width: 55.0625px\">2,000<\/td>\n<td style=\"width: 52.0625px\">1,800<\/td>\n<td style=\"width: 34.0625px\"><strong><em>27.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,200<\/td>\n<td style=\"width: 58.0625px\">2,433<\/td>\n<td style=\"width: 55.0625px\">2,311<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 45.0625px\"><strong><em>8.<\/em><\/strong><\/td>\n<td style=\"width: 50.0625px\">1,700<\/td>\n<td style=\"width: 51.0625px\">1,533<\/td>\n<td style=\"width: 46.0625px\">&#8212;<\/td>\n<td style=\"width: 32.0625px\"><strong><em>18.<\/em><\/strong><\/td>\n<td style=\"width: 55.0625px\">2,200<\/td>\n<td style=\"width: 55.0625px\">1,833<\/td>\n<td style=\"width: 52.0625px\">1,811<\/td>\n<td style=\"width: 34.0625px\"><strong><em>28.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,500<\/td>\n<td style=\"width: 58.0625px\">2,333<\/td>\n<td style=\"width: 55.0625px\">2,311<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 45.0625px\"><strong><em>9.<\/em><\/strong><\/td>\n<td style=\"width: 50.0625px\">1,300<\/td>\n<td style=\"width: 51.0625px\">1,600<\/td>\n<td style=\"width: 46.0625px\">&#8212;<\/td>\n<td style=\"width: 32.0625px\"><strong><em>19.<\/em><\/strong><\/td>\n<td style=\"width: 55.0625px\">1,900<\/td>\n<td style=\"width: 55.0625px\">1,900<\/td>\n<td style=\"width: 52.0625px\">1,911<\/td>\n<td style=\"width: 34.0625px\"><strong><em>29.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,400<\/td>\n<td style=\"width: 58.0625px\">2,300<\/td>\n<td style=\"width: 55.0625px\">2,378<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 45.0625px\"><strong><em>10.<\/em><\/strong><\/td>\n<td style=\"width: 50.0625px\">1,700<\/td>\n<td style=\"width: 51.0625px\">1,600<\/td>\n<td style=\"width: 46.0625px\">1,367<\/td>\n<td style=\"width: 32.0625px\"><strong><em>20.<\/em><\/strong><\/td>\n<td style=\"width: 55.0625px\">2,400<\/td>\n<td style=\"width: 55.0625px\">1,967<\/td>\n<td style=\"width: 52.0625px\">1,933<\/td>\n<td style=\"width: 34.0625px\"><strong><em>30.<\/em><\/strong><\/td>\n<td style=\"width: 58.0625px\">2,100<\/td>\n<td style=\"width: 58.0625px\">2,367<\/td>\n<td style=\"width: 55.0625px\">2,378<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 45.0625px\"><strong>Fig. 11.2.1<\/strong><\/td>\n<td style=\"width: 50.0625px\"><\/td>\n<td style=\"width: 51.0625px\"><\/td>\n<td style=\"width: 46.0625px\"><\/td>\n<td style=\"width: 32.0625px\"><\/td>\n<td style=\"width: 55.0625px\"><\/td>\n<td style=\"width: 55.0625px\"><\/td>\n<td style=\"width: 52.0625px\"><\/td>\n<td style=\"width: 34.0625px\"><\/td>\n<td style=\"width: 58.0625px\"><\/td>\n<td style=\"width: 58.0625px\"><\/td>\n<td style=\"width: 55.0625px\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-171\" src=\"http:\/\/mgmtp04.epgpbooks.inflibnet.ac.in\/wp-content\/uploads\/sites\/69\/2018\/10\/10.2.png\" alt=\"\" width=\"405\" height=\"218\" srcset=\"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-content\/uploads\/sites\/69\/2018\/10\/10.2.png 405w, https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-content\/uploads\/sites\/69\/2018\/10\/10.2-300x161.png 300w, https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-content\/uploads\/sites\/69\/2018\/10\/10.2-65x35.png 65w, https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-content\/uploads\/sites\/69\/2018\/10\/10.2-225x121.png 225w, https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-content\/uploads\/sites\/69\/2018\/10\/10.2-350x188.png 350w\" sizes=\"auto, (max-width: 405px) 100vw, 405px\" \/><\/p>\n<p style=\"text-align: justify\">Fig. 11.2.1 shows graphically the effects of various time periods of a moving average. It can be inferred from the graph that by using 9-week period the prediction line is much smoother and thus provides easier way of predicting next periods\u2019 demand. But 3-week moving average line clearly shows that there is sudden and sharp increase in demand after 13th week which falls suddenly after 16th week. Then there is a gradual increase in demand. Also, this line shows that growth level levels off after 23rd week. Thus, 3-week moving average responds in a better manner in following this change than the 9-week average curve. This illustration clearly demonstrates the stability effect of long term and sensitivity effect of short term.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>11.4 WEIGHTED SIMPLE MOVING AVERAGE\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">The main disadvantage of simple moving average is that the method gives equal weight age to each component of past data. This shortcoming is not too severe when data is collected over a short term period. But if moving average is calculated over a long term period like 60-day period then the problem of data reliability becomes more acute. The importance of data goes on decreasing with passage of time because of changing business conditions. The data which is very old may not be relevant in present scenario so its importance in prediction should be minimal.<\/p>\n<\/div>\n<div>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">Weighted moving average is useful in solving such discrepancy. In this method oldest data is given least weight age and most recent data the maximum weight age or importance. The sum of weights should not be more than 1. <strong><em>Example 11.3.1: <\/em><\/strong>A manager has collected sales data for last four weeks and would like to predict sales for next coming week by considering weight age to first week as least important and for recent week as most important. (Table 11.3.1)<\/p>\n<table class=\"aligncenter\" style=\"width: 300px\">\n<tbody>\n<tr>\n<td style=\"width: 135.063px\" colspan=\"5\"><strong>Table 11.3.1<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 135.063px\"><strong>Week<\/strong><\/td>\n<td style=\"width: 55.0625px\"><strong><em>1.<\/em><\/strong><\/td>\n<td style=\"width: 47.0625px\"><strong><em>2.<\/em><\/strong><\/td>\n<td style=\"width: 53.0625px\"><strong><em>3.<\/em><\/strong><\/td>\n<td style=\"width: 48.0625px\"><strong><em>4.<\/em><\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 135.063px\"><strong>Sales<\/strong><\/td>\n<td style=\"width: 55.0625px\">100<\/td>\n<td style=\"width: 47.0625px\">90<\/td>\n<td style=\"width: 53.0625px\">105<\/td>\n<td style=\"width: 48.0625px\">95<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 135.063px\"><strong>Weight age (%)<\/strong><\/td>\n<td style=\"width: 55.0625px\">10<\/td>\n<td style=\"width: 47.0625px\">20<\/td>\n<td style=\"width: 53.0625px\">30<\/td>\n<td style=\"width: 48.0625px\">40<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Forecast for 5th week<\/p>\n<p>&nbsp;<\/p>\n<p>= 0.10*100 + 0.20*90 + 0.30*105 + 0.40*95<\/p>\n<p>= 97.5 units.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">Selection of weights is prerogative of the manager by taking into consideration a simple fact: that most recent data is most accurate way of predicting next period and most past data is least reliable way of doing the same.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>11.5 EXPONENTIAL SMOOTHING\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">Exponential Smoothing is another method used for prediction of data which varies over a short term period of less than six months and does not follow any regular pattern. In previous two methods, using method of moving averages, the process of calculating averages becomes tedious if data is huge and time periods selected is also large. Exponential smoothing formula, as would be discussed below, requires only immediate three data values, namely, forecast and actual demand of immediate previous period and a smoothing coefficient.<\/p>\n<p>&nbsp;<\/p>\n<p>This method uses following formula for predicting demand or any other data:<\/p>\n<p>Ft+1 = \u03b1Dt + (1- \u03b1)Ft\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#8230;.(1)<\/p>\n<p>Where: Ft+1 = forecast for the estimated period<\/p>\n<p>Dt = actual demand for immediate previous period<\/p>\n<p>Ft = forecasted demand for immediate previous period \u03b1 = smoothing coefficient<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Selection of smoothing coefficient \u2018\u03b1\u2019:\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">The selection of a proper smoothing coefficient value can be determined by following two methods:<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">1. An \u2018\u03b1\u2019 value that results in least amount of forecasting error is considered to provide more accurate forecasting results. Forecast error is defined as the difference between forecasted and actual demand. Methods of calculating forecasting errors and their application in deciding proper \u2018\u03b1\u2019 would be discussed in next module.<\/p>\n<\/div>\n<div>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">2. Another way of determining a proper \u2018\u03b1\u2019 value is its role in smoothing an irregular data. As has been discussed this method along with method of averages, accurate forecasting depend on how data gets smoothed by using law of averages.\u00a0 Such\u00a0 methodology is adopted because\u00a0 of\u00a0 random or\u00a0 unknown pattern of variation in the data. In exponential smoothing method the random data is smoothen out by using a smoothing coefficient denoted by \u03b1. The value of this smoothing coefficient varies from 0 to 1. The formula as shown in equation (1) indicates multiplication of \u2018\u03b1\u2019 with actual demand of previous period and its opposite i.e. (1 \u2013 \u03b1) with forecasted demand of previous period. This implies that a manger would tend to use higher value of smoothing coefficient (such as 0.7, 0.8 etc.) if data of actual demand is considered more important than forecasted demand. In such a case actual demand would contribute more in estimation of next periods\u2019 demand. This can also be interpreted as, that higher value of smoothing coefficient suggests less accurate or reliable forecast for the previous period so a manager tends to give more importance to actual demand data. Similarly, a lower value of \u2018\u03b1\u2019 (such as 0.3, 0.4&#8230;etc.) would imply more accurate forecasted data whose contribution in estimating next periods\u2019 data would be more as compared to actual demand data. This has been illustrated by using following example.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\"><strong><em>Example 11.4.1: <\/em><\/strong>By using smoothing coefficient \u03b1 as 0.3 and 0.7 forecast for the following time series data (table 11.4.1) by considering actual demand of week 1 as forecast demand for week 2.<\/p>\n<table class=\"aligncenter\" style=\"width: 375px\">\n<tbody>\n<tr>\n<td style=\"width: 72.0625px\" colspan=\"11\"><strong>Table 11.4.1<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 72.0625px\"><strong>Time (in<\/strong><\/p>\n<p><strong>weeks)<\/strong><\/td>\n<td style=\"width: 29.0625px\">&nbsp;<\/p>\n<p>1<\/td>\n<td style=\"width: 32.0625px\">&nbsp;<\/p>\n<p>2<\/td>\n<td style=\"width: 31.0625px\">&nbsp;<\/p>\n<p>3<\/td>\n<td style=\"width: 28.0625px\">&nbsp;<\/p>\n<p>4<\/td>\n<td style=\"width: 31.0625px\">&nbsp;<\/p>\n<p>5<\/td>\n<td style=\"width: 29.0625px\">&nbsp;<\/p>\n<p>6<\/td>\n<td style=\"width: 32.0625px\">&nbsp;<\/p>\n<p>7<\/td>\n<td style=\"width: 31.0625px\">&nbsp;<\/p>\n<p>8<\/td>\n<td style=\"width: 31.0625px\">&nbsp;<\/p>\n<p>9<\/td>\n<td style=\"width: 29.0625px\">&nbsp;<\/p>\n<p>10<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 72.0625px\"><strong>Actual<\/strong><\/p>\n<p><strong>Demand<\/strong><\/td>\n<td style=\"width: 29.0625px\">&nbsp;<\/p>\n<p>27<\/td>\n<td style=\"width: 32.0625px\">&nbsp;<\/p>\n<p>30<\/td>\n<td style=\"width: 31.0625px\">&nbsp;<\/p>\n<p>32<\/td>\n<td style=\"width: 28.0625px\">&nbsp;<\/p>\n<p>31<\/td>\n<td style=\"width: 31.0625px\">&nbsp;<\/p>\n<p>28<\/td>\n<td style=\"width: 29.0625px\">&nbsp;<\/p>\n<p>27<\/td>\n<td style=\"width: 32.0625px\">&nbsp;<\/p>\n<p>30<\/td>\n<td style=\"width: 31.0625px\">&nbsp;<\/p>\n<p>33<\/td>\n<td style=\"width: 31.0625px\">&nbsp;<\/p>\n<p>33<\/td>\n<td style=\"width: 29.0625px\">&nbsp;<\/p>\n<p>31<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Exponential Smoothing uses following formula:<\/p>\n<p>Ft+1 = \u03b1Dt + (1- \u03b1)Ft<\/p>\n<p>By using \u03b1 = 0.3 forecast for week 2 would be<\/p>\n<table style=\"width: 392px\">\n<tbody>\n<tr>\n<td style=\"width: 108px\"><\/td>\n<td style=\"width: 140px\">F2<\/td>\n<td style=\"width: 144px\">= \u03b1D1 + (1 \u2013 \u03b1 )F1<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108px\"><\/td>\n<td style=\"width: 140px\"><\/td>\n<td style=\"width: 144px\">= 0.3*27 + 0.7*27<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108px\"><\/td>\n<td style=\"width: 140px\"><\/td>\n<td style=\"width: 144px\">= 27<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108px\">Similarly for<\/td>\n<td style=\"width: 140px\">F3<\/td>\n<td style=\"width: 144px\">= \u03b1D2 + (1 \u2013 \u03b1)F2<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108px\"><\/td>\n<td style=\"width: 140px\"><\/td>\n<td style=\"width: 144px\">= 0.3*30 + 0.7*27<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108px\"><\/td>\n<td style=\"width: 140px\"><\/td>\n<td style=\"width: 144px\">= 27.9<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">Forecast for other weeks can be calculated in similar fashion. Table 11.4.2 shows final results with forecasted demand with both \u03b1= 0.3 and \u03b1 =0.7.<\/p>\n<\/div>\n<div>\n<table class=\"aligncenter\" style=\"width: 597px\">\n<tbody>\n<tr>\n<td style=\"width: 108.063px\" colspan=\"4\"><strong>Table 11.4.2<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\"><strong>Time (in weeks)<\/strong><\/td>\n<td style=\"width: 111.063px\"><strong>Actual Demand<\/strong><\/td>\n<td style=\"width: 161.063px\"><strong>Forecast demand (\u03b1= 0.3)<\/strong><\/td>\n<td style=\"width: 160.063px\"><strong>Forecast demand (\u03b1= 0.7)<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\">1.<\/td>\n<td style=\"width: 111.063px\">27<\/td>\n<td style=\"width: 161.063px\">&#8212;&#8211;<\/td>\n<td style=\"width: 160.063px\">&#8212;&#8211;<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\">2.<\/td>\n<td style=\"width: 111.063px\">30<\/td>\n<td style=\"width: 161.063px\">27<\/td>\n<td style=\"width: 160.063px\">27<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\">3.<\/td>\n<td style=\"width: 111.063px\">32<\/td>\n<td style=\"width: 161.063px\">27.9<\/td>\n<td style=\"width: 160.063px\">29.1<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\">4.<\/td>\n<td style=\"width: 111.063px\">31<\/td>\n<td style=\"width: 161.063px\">29.13<\/td>\n<td style=\"width: 160.063px\">31.13<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\">5.<\/td>\n<td style=\"width: 111.063px\">28<\/td>\n<td style=\"width: 161.063px\">29.69<\/td>\n<td style=\"width: 160.063px\">31.03<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\">6.<\/td>\n<td style=\"width: 111.063px\">27<\/td>\n<td style=\"width: 161.063px\">29.18<\/td>\n<td style=\"width: 160.063px\">28.91<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\">7.<\/td>\n<td style=\"width: 111.063px\">30<\/td>\n<td style=\"width: 161.063px\">28.52<\/td>\n<td style=\"width: 160.063px\">27.57<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\">8.<\/td>\n<td style=\"width: 111.063px\">33<\/td>\n<td style=\"width: 161.063px\">28.97<\/td>\n<td style=\"width: 160.063px\">29.27<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\">9.<\/td>\n<td style=\"width: 111.063px\">31<\/td>\n<td style=\"width: 161.063px\">30.17<\/td>\n<td style=\"width: 160.063px\">31.88<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\">10.<\/td>\n<td style=\"width: 111.063px\">31<\/td>\n<td style=\"width: 161.063px\">30.42<\/td>\n<td style=\"width: 160.063px\">31.26<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 108.063px\"><strong>Fig. 11.4.1<\/strong><\/td>\n<td style=\"width: 111.063px\"><\/td>\n<td style=\"width: 161.063px\"><\/td>\n<td style=\"width: 160.063px\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-172\" src=\"http:\/\/mgmtp04.epgpbooks.inflibnet.ac.in\/wp-content\/uploads\/sites\/69\/2018\/10\/11.2.png\" alt=\"\" width=\"471\" height=\"187\" srcset=\"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-content\/uploads\/sites\/69\/2018\/10\/11.2.png 471w, https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-content\/uploads\/sites\/69\/2018\/10\/11.2-300x119.png 300w, https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-content\/uploads\/sites\/69\/2018\/10\/11.2-65x26.png 65w, https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-content\/uploads\/sites\/69\/2018\/10\/11.2-225x89.png 225w, https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-content\/uploads\/sites\/69\/2018\/10\/11.2-350x139.png 350w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/p>\n<p style=\"text-align: justify\">Fig. 11.4.1 clearly shows that with \u03b1 = 0.3 provides more smoothing effect to random demand data than with \u03b1 = 0.7. From this it can be inferred that forecasting done for week 11 would be more accurate by using \u03b1 = 0.3. Forecast for week 11\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 0.3*31 + 0.7*30.42<\/p>\n<p style=\"padding-left: 240px\">= 30.59<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>11.6 SUMMARY\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\">This chapter discusses methods of forecasting when demand or any other data set varies over a short term period. It has been emphasized that during such short term period it is difficult to assign a pattern to demand fluctuation. Thus, methods such as simple moving average, weighted moving average and exponential smoothing\u00a0<span style=\"font-size: 1em;text-align: initial\">which have been discussed with illustrations are applied when fluctuation in data is random and unknown. Simple moving average gives equal importance to every data value. But with passage of time old data has less relevance to present conditions. Thus, its importance decreases. So, weighted moving average was devised to give different weights to different data values depending on their occurrence in time series. Oldest data was given least importance and recent data the maximum. These two methods faced with another problem. In both the methods a manager has to carry all of data to predict for future time periods. In big data sets this becomes quite a tedious task. Exponential smoothing method helps to resolve this problem to a great extent.<\/span><\/p>\n<\/div>\n<div>\n<p>&nbsp;<\/p>\n<p><strong>11.7 GLOSSARY\u00a0<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify\"><strong><em>Time Series analysis: <\/em><\/strong>A type of forecast in which data relating to past demand are used to predict future demand.<\/li>\n<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Simple Moving Average: <\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">A forecasting technique in which every pat data value is given equal weight age.<\/span><\/li>\n<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Weighted Moving Average: <\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">A forecasting technique in which older data is given less importance than recent data.<\/span><\/li>\n<li style=\"text-align: justify\"><strong style=\"text-align: initial;font-size: 1em\"><em>Exponential \u00a0Smoothing: \u00a0<\/em><\/strong><span style=\"text-align: initial;font-size: 1em\">A \u00a0forecasting \u00a0technique \u00a0in \u00a0which \u00a0each \u00a0increment \u00a0of \u00a0past \u00a0demand \u00a0data \u00a0is decreased by (1 \u2013 \u03b1).<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>11.8 REFERENCES\/ SUGGESTED READINGS\u00a0<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify\">Chase, B.R., Shankar, R., Jacobs, F.R. and Aquilano, N.J., <em>Operations &amp; Supply Chain Management, <\/em>12th Edition, McGraw Hill.<\/li>\n<li style=\"text-align: justify\">Stevenson, W.J., <em style=\"text-align: initial;font-size: 1em\">Operations Management, <\/em><span style=\"text-align: initial;font-size: 1em\">9th Edition, Tata McGraw Hill.<\/span><\/li>\n<li style=\"text-align: justify\">Lee J. Krajewski, <em style=\"text-align: initial;font-size: 1em\">Operations Management, <\/em><span style=\"text-align: initial;font-size: 1em\">Prentice-Hall of India, New Delhi, 8th Edition.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>11.9 Short Answer Questions\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\"><strong>1.\u00a0<\/strong>Which of the following is true concerning the smoothing parameter (\u03b1) used in exponential smoothing?<\/p>\n<p>&nbsp;<\/p>\n<p>a. \u03b1 = 0.4 means the forecast for the next period is based on 40% older data and 60% recent data.<\/p>\n<p>b. If \u03b1 = 0, the forecast is equivalent to the naive forecast.<\/p>\n<p>c. The higher the value of \u03b1, the less the effect of smoothing.<\/p>\n<p>d. All of the above.<\/p>\n<p>&nbsp;<\/p>\n<p>Answer: d<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify\"><strong>2.\u00a0<\/strong>Which of the following forecasting method is not used for short term period forecast?<\/p>\n<p>&nbsp;<\/p>\n<p>a.\u00a0 Seasonal Method\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0b. Simple Moving Average<\/p>\n<p>&nbsp;<\/p>\n<p>c. Weighted Moving Average\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 d. Exponential Smoothing<\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p>Answer: a<\/p>\n<ol start=\"3\">\n<li style=\"text-align: justify\">Exponential smoothing only includes the most recent demand and ignores earlier demands, so simple moving average is better.\n<ol>\n<li>True b. False<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>Answer: b<\/p>\n<ol start=\"4\">\n<li style=\"text-align: justify\">Data forecasted by using short term periods are whereas those forecasted with longer time intervals are more\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _.<\/li>\n<\/ol>\n<p style=\"padding-left: 30px\">Answer: sensitive, stable<\/p>\n<p>&nbsp;<\/p>\n<p><strong>11.10 Model Questions<\/strong><\/p>\n<ol>\n<li style=\"text-align: justify\">What advantages does exponential smoothing method of forecasting have over moving averages?<\/li>\n<li style=\"text-align: justify\">How does the number of periods in a moving average affect the responsiveness of the forecast?<\/li>\n<li style=\"text-align: justify\">What factors are considered in the choice of exponential smoothing coefficient?<\/li>\n<li style=\"text-align: justify\">For the following data make a forecast for this week on the following basis:<\/li>\n<\/ol>\n<ul>\n<li style=\"text-align: justify\">(a) Daily using a simple four-week moving av<\/li>\n<li style=\"text-align: justify\">(b) Daily, using a weighted average of 0.40, 0.30, 0.20 and 0.10 for past four week<\/li>\n<li style=\"text-align: justify\">(c) Daily, by using smoothing coefficient of 10% for this we Take last weeks\u2019 Saturday demand as initial demand for this week\u2019s Monday.<\/li>\n<\/ul>\n<table class=\"aligncenter\">\n<tbody>\n<tr>\n<td><\/td>\n<td><strong>4 Weeks Ago<\/strong><\/td>\n<td><strong>3 Weeks Ago<\/strong><\/td>\n<td><strong>2 Weeks Ago<\/strong><\/td>\n<td><strong>Last Week<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>Monday<\/strong><\/td>\n<td>2,200<\/td>\n<td>2,400<\/td>\n<td>2,300<\/td>\n<td>2,400<\/td>\n<\/tr>\n<tr>\n<td><strong>Tuesday<\/strong><\/td>\n<td>2,000<\/td>\n<td>2,100<\/td>\n<td>2,200<\/td>\n<td>2,200<\/td>\n<\/tr>\n<tr>\n<td><strong>We<\/strong><strong>dnesday<\/strong><\/td>\n<td>2,300<\/td>\n<td>2,400<\/td>\n<td>2,300<\/td>\n<td>2,500<\/td>\n<\/tr>\n<tr>\n<td><strong>Thursday<\/strong><\/td>\n<td>1,800<\/td>\n<td>1,900<\/td>\n<td>1,800<\/td>\n<td>2,000<\/td>\n<\/tr>\n<tr>\n<td><strong>Friday<\/strong><\/td>\n<td>1,900<\/td>\n<td>1,800<\/td>\n<td>2,100<\/td>\n<td>2,000<\/td>\n<\/tr>\n<tr>\n<td><strong>Saturday<\/strong><\/td>\n<td>2800<\/td>\n<td>2700<\/td>\n<td>3000<\/td>\n<td>2900<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"author":4,"menu_order":11,"template":"","meta":{"_acf_changed":false,"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":["dr-vikas-singla"],"pb_section_license":""},"chapter-type":[],"contributor":[59],"license":[],"class_list":["post-168","chapter","type-chapter","status-publish","hentry","contributor-dr-vikas-singla"],"part":3,"_links":{"self":[{"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/pressbooks\/v2\/chapters\/168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/wp\/v2\/users\/4"}],"version-history":[{"count":4,"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/pressbooks\/v2\/chapters\/168\/revisions"}],"predecessor-version":[{"id":174,"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/pressbooks\/v2\/chapters\/168\/revisions\/174"}],"part":[{"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/pressbooks\/v2\/parts\/3"}],"metadata":[{"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/pressbooks\/v2\/chapters\/168\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/wp\/v2\/media?parent=168"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/pressbooks\/v2\/chapter-type?post=168"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/wp\/v2\/contributor?post=168"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/ebooks.inflibnet.ac.in\/mgmtp04\/wp-json\/wp\/v2\/license?post=168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}