Principles Of Operations Management
Principles Of Operations Management
11th Edition
ISBN: 9780135173930
Author: RENDER, Barry, HEIZER, Jay, Munson, Chuck
Publisher: Pearson,
bartleby

Videos

Textbook Question
Book Icon
Chapter 4, Problem 9P

Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows:

Chapter 4, Problem 9P, Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the past

a) Use a 2-month moving average on all the data and plot the averages and the prices.

b) Use a 3-month moving average and add the 3-month plot to the graph created in part (a).

c) Which is better (using the mean absolute deviation): the 2-month average or the 3-month average?

d) Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of $1.80. Use α = .1, then α = .3, and finally α = .5. Using MAD, which α is the best?

a)

Expert Solution
Check Mark
Summary Introduction

To determine:Plot and graphically represent the averages and the prices using 2-month moving average.

Introduction: Forecasting is used to predict future changes or a demand pattern. It involves different approaches and varies with different time periods. Moving average, weighted moving average and exponential smoothing are the time series methods of forecasting which uses past data to forecast the future.

Answer to Problem 9P

By using 2-month moving average, the averages and the prices are plotted.

Explanation of Solution

Given information:

Month Price Per Chip
January 1.80
February 1.67
March 1.70
April 1.85
May 1.90
June 1.87
July 1.80
August 1.83
September 1.70
October 1.65
November 1.70
December 1.75

Formula to calculate the forecasted demand

Movingaverage=demandinpreviousnperiodsn

Month Price Per Chip $ Moving Average
January 1.8
February 1.67
March 1.7 1.735
April 1.85 1.685
May 1.9 1.775
June 1.87 1.875
July 1.8 1.885
August 1.83 1.835
September 1.7 1.815
October 1.65 1.765
November 1.7 1.675
December 1.75 1.675

Table 1

Excel worksheet:

Principles Of Operations Management, Chapter 4, Problem 9P , additional homework tip  1

Calculation of the forecast for March:

Movingaverage=1.8+1.672=1.735

To calculate the forecast for March, divide the summation of the values of January and February by 2. The corresponding value 1.735 is the forecast for March. The 2-month moving average for the month of March is 1.735.

Calculation of the forecast for April:

Movingaverage=1.67+1.72=1.685

To calculate the forecast for April, divide the summation of the values of February and March by 2. The corresponding value 1.685 is the forecast for April. The 2-month moving average for the month of April is 1.685.

Calculation of the forecast for May:

Movingaverage=1.7+1.852=1.775

To calculate the forecast for May, divide the summation of the values of March and April by 2. The corresponding value 1.775 is the forecast for May. The 2-month moving average for the month of May is 1.775.

Calculation of the forecast for June:

Movingaverage=1.85+1.92=1.875

To calculate the forecast for June, divide the summation of the values of April and May by 2. The corresponding value 1.875 is the forecast for June. The 2-month moving average for the month of June is 1.875.

Calculation of the forecast for July:

Movingaverage=1.9+1.872=1.885

To calculate the forecast for July, divide the summation of the values of May and June by 2. The corresponding value 1.885 is the forecast for July. The 2-month moving average for the month of July is 1.885

Calculation of the forecast for August:

Movingaverage=1.87+1.82=1.835

To calculate the forecast for August, divide the summation of the values of June and July by 2. The corresponding value 1.835 is the forecast for August. The 2-month moving average for the month of August is 1.685.

Calculation of the forecast for September:

Movingaverage=1.8+1.832=1.815

To calculate the forecast for September, divide the summation of the values of July and August by 2. The corresponding value 1.815 is the forecast for September. The 2-month moving average for the month of September is 1.815.

Calculation of the forecast for October:

Movingaverage=1.83+1.72=1.765

To calculate the forecast for October, divide the summation of the values of August and September by 2. The corresponding value 1.765 is the forecast for October. The 2-month moving average for the month of October is 1.765.

Calculation of the forecast for November:

Movingaverage=1.7+1.652=1.675

To calculate the forecast for November, divide the summation of the values of September and October by 2. The corresponding value 1.675 is the forecast for November. The 2-month moving average for the month of November is 1.675.

Calculation of the forecast for December:

Movingaverage=1.65+1.72=1.675

To calculate the forecast for December, divide the summation of the values of October and November by 2. The corresponding value 1.675 is the forecast for December. The 2-month moving average for the month of December is 1.675.

Graph:

Principles Of Operations Management, Chapter 4, Problem 9P , additional homework tip  2

The data for 2-month moving average is obtained from Table 1. Graph is plotted with price per chip, and 2-month moving average.

Hence, the graphical representation of the averages and the prices are plotted using 2-month moving average.

b)

Expert Solution
Check Mark
Summary Introduction

To determine:Plot and graphically represent the averages and the prices using 3-month moving average.

Answer to Problem 9P

By using 3-month moving average, the averages and the prices are plotted.

Explanation of Solution

Given information:

Month Price Per Chip
January 1.80
February 1.67
March 1.70
April 1.85
May 1.90
June 1.87
July 1.80
August 1.83
September 1.70
October 1.65
November 1.70
December 1.75

Formula to calculate the forecasted demand:

Movingaverage=demandinpreviousnperiodsn

Month Price Per Chip $ Moving Average
January 1.8
February 1.67
March 1.7
April 1.85 1.723
May 1.9 1.740
June 1.87 1.817
July 1.8 1.873
August 1.83 1.857
September 1.7 1.833
October 1.65 1.777
November 1.7 1.727
December 1.75 1.683

Table 2

Excel worksheet:

Principles Of Operations Management, Chapter 4, Problem 9P , additional homework tip  3

Calculation of the forecast for April:

Movingaverage=1.8+1.67+1.72=1.723

To calculate the forecast for April, divide the summation of the values of January, February and March by 3. The corresponding value 1.732 is the forecast for April. Therefore, 3-month moving average for the month of April is 1.723.

Calculation of the forecast for May:

Movingaverage=1.67+1.7+1.852=1.740

To calculate the forecast for May, divide the summation of the values of February, March and April by 3. The corresponding value 1.740 is the forecast for May. Therefore, 3-month moving average for the month of May is 1.740.

Calculation of the forecast for June:

Movingaverage=1.7+1.85+1.92=1.817

To calculate the forecast for June, divide the summation of the values of March, April and May by 3. The corresponding value 1.817 is the forecast for June. Therefore, 3-month moving average for the month of June is 1.817.

Calculation of the forecast for July:

Movingaverage=1.85+1.9+1.872=1.873

To calculate the forecast for July, divide the summation of the values of April, May and June by 3. The corresponding value 1.873 is the forecast for July. Therefore, 3-month moving average for the month of July is 1.873.

Calculation of the forecast for August:

Movingaverage=1.9+1.87+1.82=1.873

To calculate the forecast for August, divide the summation of the values of May, June and July by 3. The corresponding value 1.873 is the forecast for August. Therefore, 3-month moving average for the month of August is 1.873.

Calculation of the forecast for September:

Movingaverage=1.87+1.8+1.832=1.833

To calculate the forecast for September, divide the summation of the values of June, July and August by 3. The corresponding value 1.833 is the forecast for September. Therefore, 3-month moving average for the month of June is 1.833.

Calculation of the forecast for October:

Movingaverage=1.8+1.83+1.72=1.777

To calculate the forecast for October, divide the summation of the values of July, August and September by 3. The corresponding value 1.777 is the forecast for October. Therefore, 3-month moving average for the month of June is 1.777.

Calculation of the forecast for November:

Movingaverage=1.83+1.7+1.652=1.727

To calculate the forecast for November, divide the summation of the values of August, September and October by 3. The corresponding value 1.727 is the forecast for November. Therefore, 3-month moving average for the month of November is 1.727.

Calculation of the forecast for December:

Movingaverage=1.7+1.65+1.72=1.683

To calculate the forecast for December, divide the summation of the values of September, October and November by 3. The corresponding value 1.683 is the forecast for December. Therefore, 3-month moving average for the month of December is 1.683.

Graph:

Principles Of Operations Management, Chapter 4, Problem 9P , additional homework tip  4

The data for 3-month moving average is obtained from Table 2. Graph is plotted with price per chip, and 3-month moving average.

Hence, the graphical representation of the averages and the prices are plotted using 3-month moving average.

c)

Expert Solution
Check Mark
Summary Introduction

To determine:Compute the Mean Absolute Deviation (MAD) using 2-month moving average and 3-month moving average and from the results, infer the superior method.

Answer to Problem 9P

MAD from 2-month moving average and 3-month moving average are 0.075 & 0.079 (refer to equations (1) & (2)). Because of less deviation of error, MAD from a 2-month moving average is superior over a 3-month moving average.

Explanation of Solution

Given information:

Month Price Per Chip
January 1.80
February 1.67
March 1.70
April 1.85
May 1.90
June 1.87
July 1.80
August 1.83
September 1.70
October 1.65
November 1.70
December 1.75

Formula to calculate MAD:

MAD=|Actual-Forecast|n

Calculation of MAD using 2-month moving average:

Table 1 provides the calculation of forecast using 2-month moving average.

Month Price Per Chip $ 2-month moving average Absolute error
January 1.8
February 1.67
March 1.7 1.735 0.035
April 1.85 1.685 0.165
May 1.9 1.775 0.125
June 1.87 1.875 0.005
July 1.8 1.885 0.085
August 1.83 1.835 0.005
September 1.7 1.815 0.115
October 1.65 1.765 0.115
November 1.7 1.675 0.025
December 1.75 1.675 0.075
Total 0.75
MAD 0.075

Excel worksheet:

Principles Of Operations Management, Chapter 4, Problem 9P , additional homework tip  5

Calculation of the absolute error for March:

Absoluteerror=|Actual-Forecast|=|1.7-1.735|=|-0.035|=0.035

Absolute Error of March is the modulus of the difference between 1.7 and 1.735, which corresponds to 0.035. Therefore Absolute Error for March is 0.035.

Calculation of the absolute error for April:

Absoluteerror=|Actual-Forecast|=|1.851.685|=|0.165|=0.165

Absolute Error of April is the modulus of the difference between 1.85 and 1.685, which corresponds to 0.165. Therefore Absolute Error for April is 0.165.

Calculation of the absolute error for May:

Absoluteerror=|Actual-Forecast|=|1.91.775|=|0.125|=0.125

Absolute Error of May is the modulus of the difference between 1.9 and 1.775, which corresponds to 0.125. Therefore Absolute Error for May is 0.125.

Calculation of the absolute error for June:

Absoluteerror=|Actual-Forecast|=|1.871.875|=|-0.005|=0.005

Absolute Error of June is the modulus of the difference between 1.87 and 1.875, which corresponds to 0.005. Therefore Absolute Error for June is 0.005.

Calculation of the absolute error for July:

Absoluteerror=|Actual-Forecast|=|1.81.885|=|-0.085|=0.085

Absolute Error of July is the modulus of the difference between 1.8 and 1.885, which corresponds to 0.085. Therefore Absolute Error for July is 0.085.

Calculation of the absolute error for August:

Absoluteerror=|Actual-Forecast|=|1.831.835|=|-0.005|=0.005

Absolute Error of August is the modulus of the difference between 1.83 and 1.835, which corresponds to 0.005. Therefore Absolute Error for August is 0.005.

Calculation of the absolute error for September:

Absoluteerror=|Actual-Forecast|=|1.71.815|=|-0.115|=0.115

Absolute Error of September is the modulus of the difference between 1.7 and 1.815, which corresponds to 0.115. Therefore Absolute Error for September is 0.115.

Calculation of the absolute error for October:

Absoluteerror=|Actual-Forecast|=|1.651.765|=|-0.115|=0.115

Absolute Error of October is the modulus of the difference between 1.65 and 1.765, which corresponds to 0.115. Therefore Absolute Error for October is 0.115.

Calculation of the absolute error for November:

Absoluteerror=|Actual-Forecast|=|1.71.675|=|0.025|=0.025

Absolute Error of November is the modulus of the difference between 1.7 and 1.675, which corresponds to 0.025. Therefore Absolute Error for November is 0.025.

Calculation of the absolute error for December:

Absoluteerror=|Actual-Forecast|=|1.751.675|=|0.075|=0.075

Absolute Error of December is the modulus of the difference between 1.75 and 1.675, which corresponds to 0.075. Therefore Absolute Error for December is 0.075.

Calculation of MAD using 2-month moving average:

Mean Absolute Deviation is obtained by dividing the summation of absolute values by the number of years. Absolute error is obtained by taking modulus for the difference between Actual and forecasted values.

MAD=|Actual-Forecast|n=0.035+0.165+0.125+0.005+0.085+0.005+0.115+0.115+0.025+0.07510=0.7510=0.075 (1)

Substitute the summation value of absolute error for 10 years i.e. 0.75 is divided by number of years i.e. 10 yields MAD of 0.075

The Mean Absolute Deviation using 2-month moving average is 0.075

Calculation of MAD using 3-month moving average

Table 2 provides the value of 3-month moving average

Month Price Per Chip $ 3-month Moving Average Absolute error
January 1.8
February 1.67
March 1.7
April 1.85 1.723 0.127
May 1.9 1.740 0.160
June 1.87 1.817 0.053
July 1.8 1.873 0.073
August 1.83 1.857 0.027
September 1.7 1.833 0.133
October 1.65 1.777 0.127
November 1.7 1.727 0.027
December 1.75 1.683 0.067
Total 0.793
MAD 0.079

Excel worksheet:

Principles Of Operations Management, Chapter 4, Problem 9P , additional homework tip  6

Calculation of the Absolute Error for April:

Absoluteerror=|Actual-Forecast|=|1.851.723|=|0.127|=0.127

Absolute Error of April is the modulus of the difference between 1.85 and 1.723, which corresponds to 0.127. Absolute Error for April is 0.127

Calculation of the Absolute Error for May:

Absoluteerror=|Actual-Forecast|=|1.91.740|=|0.160|=0.160

Absolute Error of May is the modulus of the difference between 1.9 and 1.740, which corresponds to 0.160. Therefore Absolute Error for May is 0.160

Calculation of the Absolute Error for June:

Absoluteerror=|Actual-Forecast|=|1.871.817|=|0.053|=0.053

Absolute Error of June is the modulus of the difference between 1.87 and 1.817, which corresponds to 0.053. Therefore Absolute Error for June is 0.053

Calculation of the Absolute Error for July:

Absoluteerror=|Actual-Forecast|=|1.81.873|=|0.073|=0.073

Absolute Error of July is the modulus of the difference between 1.8 and 1.873, which corresponds to 0.073. Absolute Error for July is 0.073.

Calculation of the Absolute Error for August:

Absoluteerror=|Actual-Forecast|=|1.831.857|=|0.027|=0.027

Absolute Error of August is the modulus of the difference between 1.83 and 1.857, which corresponds to 0.027. Therefore, Absolute Error for August is 0.027.

Calculation of the Absolute Error for September:

Absoluteerror=|Actual-Forecast|=|1.71.833|=|-0.133|=0.133

Absolute Error of September is the modulus of the difference between 1.7 and 1.833, which corresponds to 0.133. Therefore Absolute Error for September is 0.133.

Calculation of the Absolute Error for October:

Absoluteerror=|Actual-Forecast|=|1.651.777|=|-0.127|=0.127

Absolute Error of October is the modulus of the difference between 1.65 and 1.777, which corresponds to 0.127. Therefore Absolute Error for October is 0.127.

Calculation of the Absolute Error for November:

Absoluteerror=|Actual-Forecast|=|1.71.727|=|-0.027|=0.027

Absolute Error of November is the modulus of the difference between 1.7 and 1.727, which corresponds to 0.027. Therefore Absolute Error for November is 0.027

Calculation of the Absolute Error for December:

Absoluteerror=|Actual-Forecast|=|1.751.683|=|0.067|=0.067

Absolute Error of December is the modulus of the difference between 1.75 and 1.683, which corresponds to 0.067. Therefore Absolute Error for December is 0.067

Calculation of MAD using 3-month moving average:

MAD=|Actual-Forecast|n=0.127+0.160+0.053+0.073+0.027+0.133+0.127+0.027+0.0679=0.7939=0.079 (2)

Substitute the summation value of absolute error for 10 years i.e. 0.793 is divided by number of years i.e. 9 yields MAD of 0.079. Mean Absolute Deviation using 3-month moving average is 0.079

Hence, the Mean Absolute Deviation from the 2-month moving average is 0.075 (refer to equation (1)) and from the 3-month moving average is 0.079 (refer to equation (2)). Due to less deviation of error, the MAD from the 2-month moving average is superior to that of the 3-month moving average.

d)

Expert Solution
Check Mark
Summary Introduction

To determine: Decide the best method by computing Mean Absolute Duration using exponential smoothing with α = 0.1, α = 0.3 and α = 0.5

Answer to Problem 9P

The Mean Absolute Deviation using exponential smoothing using α = 0.1 is 0.071, (refer to equation 3), α = 0.3 is 0.070 (refer to equation 4) and α = 0.5 is 0.066 (refer to equation 5). MAD using α = 0.5 is the best method since the MAD is minimum.

Explanation of Solution

Given information:

Month Price Per Chip
January 1.80
February 1.67
March 1.70
April 1.85
May 1.90
June 1.87
July 1.80
August 1.83
September 1.70
October 1.65
November 1.70
December 1.75

The initial forecast for the month of January is $1.80

Formula to calculate the forecasted demand

Ft=Ft-1+α(At-1-Ft-1)

Where,

Ft=newforecastFt-1=Previousperiod'sforecastα=smoothingconstantAt-1=PreviousperiodactualDemand

Calculation of MAD using exponential smoothing with smoothing constant α = 0.1

Sl. No. Month Price Per Chip $ Forecast Absolute error
1 January 1.8 1.8 0
2 February 1.67 1.8 0.130
3 March 1.7 1.787 0.087
4 April 1.85 1.778 0.072
5 May 1.9 1.785 0.115
6 June 1.87 1.797 0.073
7 July 1.8 1.804 0.004
8 August 1.83 1.804 0.026
9 September 1.7 1.806 0.106
10 October 1.65 1.796 0.146
11 November 1.7 1.781 0.081
12 December 1.75 1.773 0.023
Total 0.8632
MAD 0.0719

Excel worksheet:

Principles Of Operations Management, Chapter 4, Problem 9P , additional homework tip  7

Calculation of absolute error for January:

Absoluteerror=|Actual-Forecast|=|1.81.8|=|0|=0

Absolute Error of January is the modulus of the difference between 1.8 and 1.8, which corresponds to 0. Therefore Absolute Error for January is 0

Calculation of the forecast & absolute error for February:

F2=F1+α(A1-F1)=1.8+0.1(1.81.8)=1.8

Absoluteerror=|Actual-Forecast|=|1.671.8|=|0.130|=0.130

To calculate forecast for February, substitute the value of forecast of January, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for February is 1.8

Absolute Error of February is the modulus of the difference between 1.67 and 1.8, which corresponds to 0.130 Therefore Absolute Error for February, is 0.130

Forecast and Absolute error for February is 1.8 & 0.130

Calculation of the forecast & absolute error for March:

F3=F2+α(A2-F2)=1.8+0.1(1.671.8)=1.787

Absoluteerror=|Actual-Forecast|=|1.71.787|=|0.087|=0.087

To calculate forecast for March, substitute the value of forecast of February, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for March is 1.787

Absolute Error of March is the modulus of the difference between 1.7 and 1.787, which corresponds to 0.087 Therefore Absolute Error for March, is 0.087

Forecast and Absolute error for March is 1.787 & 0.087

Calculation of the forecast & absolute error for April:

F4=F3+α(A3-F3)=1.787+0.1(1.71.787)=1.778

Absoluteerror=|Actual-Forecast|=|1.851.778|=|0.072|=0.072

To calculate forecast for April, substitute the value of forecast of March, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for April is 1.778.

Absolute Error of April is the modulus of the difference between 1.85 and 1.778, which corresponds to 0.072. Therefore Absolute Error for April is 0.087.

Forecast and Absolute error for April is 1.778 & 0.072.

Calculation of the forecast & absolute error for May:

F5=F4+α(A4-F4)=1.778+0.1(1.851.778)=1.785

Absoluteerror=|Actual-Forecast|=|1.91.785|=|0.115|=0.115

To calculate forecast for May, substitute the value of forecast of April, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for May is 1.785

Absolute Error of May is the modulus of the difference between 1.9 and 1.785, which corresponds to 0.115. Therefore Absolute Error for May is 0.115

Forecast and Absolute error for May is 1.785 & 0.115

Calculation of the forecast & absolute error for June:

F6=F5+α(A5-F5)=1.785+0.1(1.91.785)=1.797

Absoluteerror=|Actual-Forecast|=|1.871.797|=|0.073|=0.073

To calculate forecast for June, substitute the value of forecast of May, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for June is 1.797.

Absolute Error of June is the modulus of the difference between 1.87 and 1.797, which corresponds to 0.073. Therefore Absolute Error for June is 0.073.

Forecast and Absolute error for June is 1.797 & 0.073.

Calculation of the forecast & absolute error for July:

F7=F6+α(A6-F6)=1.797+0.1(1.871.797)F7=1.804

Absoluteerror=|Actual-Forecast|=|1.81.804|=|0.004|=0.004

To calculate forecast for July, substitute the value of forecast of June, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for July is 1.804

Absolute Error of July is the modulus of the difference between 1.8 and 1.804, which corresponds to 0.004. Therefore Absolute Error for July is 0.004

Forecast and Absolute error for July is 1.804 & 0.004

Calculation of the forecast & absolute error for August:

F8=F7+α(A7-F7)=1.804+0.1(1.81.804)F8=1.804

Absoluteerror=|Actual-Forecast|=|1.831.804|=|0.026|=0.026

To calculate forecast for August, substitute the value of forecast of July, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for August is 1.804

Absolute Error of August is the modulus of the difference between 1.83 and 1.804, which corresponds to 0.026. Therefore Absolute Error for July is 0.026

Forecast and Absolute error for August is 1.804 & 0.026

Calculation of the forecast & absolute error for September:

F9=F8+α(A8-F8)=1.804+0.1(1.831.804)F9=1.806

Absoluteerror=|Actual-Forecast|=|1.71.806|=|0.106|=0.106

To calculate forecast for September, substitute the value of forecast of August, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for September is 1.806

Absolute Error of September is the modulus of the difference between 1.7 and 1.806, which corresponds to 0.106 Therefore Absolute Error for September, is 0.106

Forecast and Absolute error for September is 1.806 & 0.106

Calculation of the forecast & absolute error for October:

F10=F9+α(A9-F9)=1.806+0.1(1.71.806)F9=1.796

Absoluteerror=|Actual-Forecast|=|1.651.796|=|0.146|=0.146

To calculate forecast for October, substitute the value of forecast of September, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for October is 1.796

Absolute Error of October is the modulus of the difference between 1.65 and 1.796, which corresponds to 0.146 Therefore Absolute Error for October, is 0.146

Forecast and Absolute error for October is 1.796 & 0.146

Calculation of the forecast & absolute error for November:

F11=F10+α(A10-F10)=1.796+0.1(1.651.796)F11=1.781

Absoluteerror=|Actual-Forecast|=|1.71.781|=|0.081|=0.081

To calculate forecast for November, substitute the value of forecast of October, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for November is 1.781.

Absolute Error of November is the modulus of the difference between 1.7 and 1.781, which corresponds to 0.081 Therefore Absolute Error for November, is 0.081.

Forecast and Absolute error for November is 1.781 & 0.081.

Calculation of the forecast & absolute error for December:

F12=F11+α(A11-F11)=1.781+0.1(1.71.781)=1.773

Absoluteerror=|Actual-Forecast|=|1.751.773|=|0.023|=0.023

To calculate forecast for December, substitute the value of forecast of November, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for December is 1.773.

Absolute Error of December is the modulus of the difference between 1.75 and 1.773, which corresponds to 0.023. Therefore Absolute Error for December is 0.023.

Forecast and Absolute error for December is 1.773 & 0.023.

Calculation of MAD:

MAD=|Actual-Forecast|n=(0+0.130+0.087+0.072+0.115+0.073+0.004+0.026+0.106+0.146+0.081+0.023)12=0.862312=0.0719 (3)

Upon substitution of summation value of absolute error for 12 years i.e. 0.8623 is divided by number of years i.e. 12 yields MAD of 0.0719

Mean Absolute Deviation using exponential smoothing with smoothing constant α = 0.1 is 0.0719

Calculation of MAD using exponential smoothing with smoothing constant α = 0.3

Sl. No. Month Price Per Chip $ Forecast Absolute error
1 January 1.8 1.8 0
2 February 1.67 1.800 0.130
3 March 1.7 1.761 0.061
4 April 1.85 1.743 0.107
5 May 1.9 1.775 0.125
6 June 1.87 1.812 0.058
7 July 1.8 1.830 0.030
8 August 1.83 1.821 0.009
9 September 1.7 1.824 0.124
10 October 1.65 1.786 0.136
11 November 1.7 1.746 0.046
12 December 1.75 1.732 0.018
Total 0.844
MAD 0.070

Excel worksheet:

Principles Of Operations Management, Chapter 4, Problem 9P , additional homework tip  8

Calculation of the absolute error for January:

Absoluteerror=|Actual-Forecast|=|1.81.8|=|0|=0

Absolute Error of January is the modulus of the difference between 1.8 and 1.8, which corresponds to 0. Therefore Absolute Error for January is 0

Calculation of the forecast & absolute error for February:

F2=F1+α(A1-F1)=1.8+0.3(1.81.8)=1.800

Absoluteerror=|Actual-Forecast|=|1.671.80|=|0.130|=0.130

To calculate forecast for February, substitute the value of forecast of January, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for February is 1.8.

Absolute Error of February is the modulus of the difference between 1.67 and 1.8, which corresponds to 0.130 Therefore Absolute Error for February, is 0.130.

Forecast and Absolute error for February is 1.800 & 0.130.

Calculation of the forecast & absolute error for March:

F3=F2+α(A2-F2)=1.8+0.3(1.671.8)=1.761

Absoluteerror=|Actual-Forecast|=|1.71.761|=|0.061|=0.061

To calculate forecast for March, substitute the value of forecast of February, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for March is 1.761.

Absolute Error of March is the modulus of the difference between 1.7 and 1.761, which corresponds to 0.061 Therefore Absolute Error for March, is 0.061.

Forecast and Absolute error for March is 1.761 & 0.061.

Calculation of the forecast & absolute error for April:

F4=F3+α(A3-F3)=1.761+0.3(1.71.761)=1.743

Absoluteerror=|Actual-Forecast|=|1.851.743|=|0.107|=0.107

To calculate forecast for April, substitute the value of forecast of March, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for April is 1.743.

Absolute Error of April is the modulus of the difference between 1.85 and 1.743, which corresponds to 0.107. Therefore Absolute Error for April is 0.107.

Forecast and Absolute error for April is 1.743 & 0.107.

Calculation of the forecast & absolute error for May:

F5=F4+α(A4-F4)=1.743+0.3(1.851.743)=1.775

Absoluteerror=|Actual-Forecast|=|1.91.775|=|0.125|=0.125

To calculate forecast for May, substitute the value of forecast of April, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for May is 1.775.

Absolute Error of May is the modulus of the difference between 1.9 and 1.775, which corresponds to 0.125. Therefore Absolute Error for May is 0.125.

Forecast and Absolute error for May is 1.775 & 0.125.

Calculation of the forecast & absolute error for June:

F6=F5+α(A5-F5)=1.775+0.3(1.91.775)=1.812

Absoluteerror=|Actual-Forecast|=|1.871.812|=|0.058|=0.058

To calculate forecast for June, substitute the value of forecast of May, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for June is 1.812.

Absolute Error of June is the modulus of the difference between 1.87 and 1.812, which corresponds to 0.058. Therefore Absolute Error for June is 0.058.

Forecast and Absolute error for June is 1.812 & 0.058.

Calculation of the forecast & absolute error for July:

F7=F6+α(A6-F6)=1.812+0.3(1.871.812)F7=1.830

Absoluteerror=|Actual-Forecast|=|1.81.830|=|0.030|=0.030

To calculate forecast for July, substitute the value of forecast of June, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for July is 1.830.

Absolute Error of July is the modulus of the difference between 1.8 and 1.830, which corresponds to 0.030. Therefore Absolute Error for July is 0.030.

Forecast and Absolute error for July is 1.830 & 0.030.

Calculation of the forecast & absolute error for August:

F8=F7+α(A7-F7)=1.830+0.3(1.81.830)F8=1.821

Absoluteerror=|Actual-Forecast|=|1.831.821|=|0.009|=0.009

To calculate forecast for August, substitute the value of forecast of July, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for August is 1.821.

Absolute Error of August is the modulus of the difference between 1.83 and 1.821, which corresponds to 0.009. Therefore Absolute Error for July is 0.009.

Forecast and Absolute error for August is 1.821 & 0.009.

Calculation of the forecast & absolute error for September:

F9=F8+α(A8-F8)=1.821+0.3(1.831.821)F9=1.824

Absoluteerror=|Actual-Forecast|=|1.71.824|=|0.124|=0.124

To calculate forecast for September, substitute the value of forecast of August, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for September is 1.824.

Absolute Error of September is the modulus of the difference between 1.7 and 1.824, which corresponds to 0.124 Therefore Absolute Error for September, is 0.124.

Forecast and Absolute error for September is 1.824 & 0.124.

Calculation of the forecast & absolute error for October:

F10=F9+α(A9-F9)=1.824+0.3(1.71.824)F10=1.786

Absoluteerror=|Actual-Forecast|=|1.651.786|=|0.136|=0.136

To calculate forecast for October, substitute the value of forecast of September, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for October is 1.786.

Absolute Error of October is the modulus of the difference between 1.65 and 1.786, which corresponds to 0.146 Therefore Absolute Error for October, is 0.136.

Forecast and Absolute error for October is 1.786 & 0.136.

Calculation of the forecast & absolute error for November:

F11=F10+α(A10-F10)=1.786+0.3(1.651.786)F11=1.746

Absoluteerror=|Actual-Forecast|=|1.71.746|=|0.046|=0.046

To calculate forecast for November, substitute the value of forecast of October, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for November is 1.746.

Absolute Error of November is the modulus of the difference between 1.7 and 1.746, which corresponds to 0.046 Therefore Absolute Error for November, is 0.046.

Forecast and Absolute error for November is 1.746 & 0.046.

Calculation of the forecast & absolute error for December:

F12=F11+α(A11-F11)=1.746+0.3(1.71.746)=1.732

Absoluteerror=|Actual-Forecast|=|1.751.732|=|0.018|=0.018

To calculate forecast for December, substitute the value of forecast of November, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for December is 1.732.

Absolute Error of December is the modulus of the difference between 1.75 and 1.773, which corresponds to 0.018. Therefore Absolute Error for December is 0.018.

Forecast and Absolute error for December is 1.732 & 0.018.

Calculation of the Mean Absolute Deviation:

MAD=|Actual-Forecast|n=(0+0.130+0.061+0.107+0.125+0.058+0.030+0.009+0.124+0.136+0.046+0.018)12=0.84412=0.070 (4)

Upon substitution of summation value of absolute error for 12 years i.e. 0.844 is divided by number of years i.e. 12 yields MAD of 0.070.

Mean Absolute Deviation using exponential smoothing with smoothing constant α = 0.3 is 0.070

Calculation of MAD using exponential smoothing with smoothing constant α = 0.5

Sl. No. Month Price Per Chip $ Forecast Absolute error
1 January 1.8 1.8 0
2 February 1.67 1.800 0.130
3 March 1.7 1.735 0.035
4 April 1.85 1.718 0.133
5 May 1.9 1.784 0.116
6 June 1.87 1.842 0.028
7 July 1.8 1.856 0.056
8 August 1.83 1.828 0.002
9 September 1.7 1.829 0.129
10 October 1.65 1.764 0.114
11 November 1.7 1.707 0.007
12 December 1.75 1.704 0.046
Total 0.797
MAD 0.066

Excel worksheet:

Principles Of Operations Management, Chapter 4, Problem 9P , additional homework tip  9

Calculation of the absolute error for January:

Absoluteerror=|Actual-Forecast|=|1.81.8|=|0|=0

Absolute Error of January is the modulus of the difference between 1.8 and 1.8, which corresponds to 0. Therefore Absolute Error for January is 0

Absolute Error for January is 0

Calculation of the forecast & absolute error for February:

F2=F1+α(A1-F1)=1.8+0.5(1.81.8)=1.8

Absoluteerror=|Actual-Forecast|=|1.671.80|=|0.130|=0.130

To calculate forecast for February, substitute the value of forecast of January, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for February is 1.8

Absolute Error of February is the modulus of the difference between 1.67 and 1.8, which corresponds to 0.130 Therefore Absolute Error for February, is 0.130

Forecast and Absolute error for February is 1.8 & 0.130

Calculation of the forecast & absolute error for March:

F3=F2+α(A2-F2)=1.8+0.5(1.671.8)=1.735

Absoluteerror=|Actual-Forecast|=|1.71.735|=|0.035|=0.035

To calculate forecast for March, substitute the value of forecast of February, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for March is 1.735

Absolute Error of March is the modulus of the difference between 1.7 and 1.735, which corresponds to 0.035 Therefore Absolute Error for March, is 0.035

Forecast and Absolute error for March is 1.735 & 0.035

Calculation of the forecast & absolute error for April:

F4=F3+α(A3-F3)=1.735+0.5(1.71.735)=1.718

Absoluteerror=|Actual-Forecast|=|1.851.718|=|0.133|=0.133

To calculate forecast for April, substitute the value of forecast of March, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for April is 1.718

Absolute Error of April is the modulus of the difference between 1.85 and 1.718, which corresponds to 0.133. Therefore Absolute Error for April is 0.133

Forecast and Absolute error for April is 1.718 & 0.133

Calculation of the forecast & absolute error for May:

F5=F4+α(A4-F4)=1.718+0.5(1.851.718)=1.784

Absoluteerror=|Actual-Forecast|=|1.91.784|=|0.116|=0.116

To calculate forecast for May, substitute the value of forecast of April, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for May is 1.784

Absolute Error of May is the modulus of the difference between 1.9 and 1.784, which corresponds to 0.116. Therefore Absolute Error for May is 0.116

Forecast and Absolute error for May is 1.784 & 0.116

Calculation of the forecast & absolute error for June:

F6=F5+α(A5-F5)=1.784+0.5(1.91.784)=1.842

Absoluteerror=|Actual-Forecast|=|1.871.842|=|0.028|=0.028

To calculate forecast for June, substitute the value of forecast of May, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for June is 1.842.

Absolute Error of June is the modulus of the difference between 1.87 and 1.842, which corresponds to 0.028. Therefore Absolute Error for June is 0.028.

Forecast and Absolute error for June is 1.842 & 0.028.

Calculation of the forecast & absolute error for July:

F7=F6+α(A6-F6)=1.842+0.5(1.871.842)F7=1.856

Absoluteerror=|Actual-Forecast|=|1.81.856|=|0.056|=0.056

To calculate forecast for July, substitute the value of forecast of June, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for July is 1.856.

Absolute Error of July is the modulus of the difference between 1.8 and 1.856, which corresponds to 0.056. Therefore Absolute Error for July is 0.056.

Forecast and Absolute error for July is 1.856 & 0.056.

Calculation of the forecast & absolute error for August:

F8=F7+α(A7-F7)=1.856+0.5(1.81.856)F8=1.828

Absoluteerror=|Actual-Forecast|=|1.831.828|=|0.002|=0.002

To calculate forecast for August, substitute the value of forecast of July, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for August is 1.828.

Absolute Error of August is the modulus of the difference between 1.83 and 1.828, which corresponds to 0.002. Therefore Absolute Error for July is 0.002.

Forecast and Absolute error for August is 1.828 & 0.002.

Calculation of the forecast & absolute error for September:

F9=F8+α(A8-F8)=1.825+0.5(1.831.828)F9=1.829

Absoluteerror=|Actual-Forecast|=|1.71.829|=|0.129|=0.129

To calculate forecast for September, substitute the value of forecast of August, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for September is 1.829.

Absolute Error of September is the modulus of the difference between 1.7 and 1.829, which corresponds to 0.129 Therefore Absolute Error for September, is 0.129.

Forecast and Absolute error for September is 1.829 & 0.129.

Calculation of the forecast & absolute error for October:

F10=F9+α(A9-F9)=1.829+0.5(1.71.829)F10=1.764

Absoluteerror=|Actual-Forecast|=|1.651.764|=|0.114|=0.114

To calculate forecast for October, substitute the value of forecast of September, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for October is 1.764.

Absolute Error of October is the modulus of the difference between 1.65 and 1.764, which corresponds to 0.114 Therefore Absolute Error for October, is 0.114.

Forecast and Absolute error for October is 1.764 & 0.114.

Calculation of the forecast & absolute error for November:

F11=F10+α(A10-F10)=1.764+0.5(1.651.764)F11=1.707

Absoluteerror=|Actual-Forecast|=|1.71.707|=|0.007|=0.007

To calculate forecast for November, substitute the value of forecast of October, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for November is 1.707.

Absolute Error of November is the modulus of the difference between 1.7 and 1.707, which corresponds to 0.007 Therefore Absolute Error for November, is 0.007.

Forecast and Absolute error for November is 1.707 & 0.007.

Calculation of the forecast & absolute error for December:

F12=F11+α(A11-F11)=1.707+0.5(1.71.707)=1.704

Absoluteerror=|Actual-Forecast|=|1.751.704|=|0.046|=0.046

To calculate forecast for December, substitute the value of forecast of November, smoothing constant and difference of actual and forecasted demand in the above formula. The result of forecast for December is 1.704.

Absolute Error of December is the modulus of the difference between 1.75 and 1.704, which corresponds to 0.046. Therefore Absolute Error for December is 0.046.

Forecast and Absolute error for December is 1.704 & 0.046.

Calculation of the Mean Absolute Deviation:

MAD=|Actual-Forecast|n=(0+0.130+0.035+0.133+0.116+0.028+0.056+0.002+0.0129+0.114+0.007+0.046)12=0.79712=0.066 (5)

Upon substitution of summation value of absolute error for 11 years i.e. 0.797 is divided by number of years i.e. 12 yields MAD of 0.066.

Mean Absolute Deviation using exponential smoothing with smoothing constant α = 0.1 is 0.066

Hence, the Mean Absolute Deviation using exponential smoothing using α = 0.1 is 0.071, (refer equation 3) α = 0.3 is 0.070 (refer equation 4) and α = 0.5 is 0.066 (refer equation 5). MAD using α = 0.5 is the best method since the MAD is minimum.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows:                                                                                                                a) Use a 2-month moving average on all the data and plot the averages and the prices.b) Use a 3-month moving average a nd add the 3-month plot to the graph created in part (a).c) Which is better (using the mean absolute deviation): the 2-month average or the 3-month average?d) Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of $1.80. Use a = .I, then a = .3, and finally a = .5. Using MAD, whicha is the best?
Lenovo uses the ZX-81 chip in some of its laptopcomputers. The prices for the chip during the past 12 monthswere as follows:   a) Use a 2-month moving average on all the data and plot theaverages and the prices.b) Use a 3-month moving average and add the 3-month plot tothe graph created in part (a).c) Which is better (using the mean absolute deviation): the2-month average or the 3-month average?d) Compute the forecasts for each month using exponentialsmoothing, with an initial forecast for January of $1.80. Use a= .1, then a = .3, and finally a = .5. Using MAD, which ais the best?
1

Chapter 4 Solutions

Principles Of Operations Management

Ch. 4 - What is the primary difference between a...Ch. 4 - Define time series.Ch. 4 - What effect does the value of the smoothing...Ch. 4 - Explain the value of seasonal indices in...Ch. 4 - Prob. 14DQCh. 4 - In your own words, explain adaptive forecasting.Ch. 4 - Prob. 16DQCh. 4 - Explain, in your own words, the meaning of the...Ch. 4 - Prob. 18DQCh. 4 - Give examples of industries that are affected by...Ch. 4 - Prob. 20DQCh. 4 - Prob. 21DQCh. 4 - CEO John Goodale, at Southern Illinois Power and...Ch. 4 - The following gives the number of pints of type B...Ch. 4 - a) Plot the above data on a graph. Do you observe...Ch. 4 - Refer to Problem 4.2. Develop a forecast for years...Ch. 4 - A check-processing center uses exponential...Ch. 4 - The Carbondale Hospital is considering the...Ch. 4 - The monthly sales for Yazici Batteries, Inc., were...Ch. 4 - Prob. 7PCh. 4 - Daily high temperatures in St. Louis for the last...Ch. 4 - Lenovo uses the ZX-81 chip in some of its laptop...Ch. 4 - Data collected on the yearly registrations for a...Ch. 4 - Use exponential smoothing with a smoothing...Ch. 4 - Prob. 12PCh. 4 - At you can see in the following table, demand for...Ch. 4 - Prob. 14PCh. 4 - Refer to Solved Problem 4.1 on page 144. a) Use a...Ch. 4 - Prob. 16PCh. 4 - Prob. 17PCh. 4 - Prob. 18PCh. 4 - Income at the architectural firm Spraggins and...Ch. 4 - Resolve Problem 4.19 with = .1 and =.8. Using...Ch. 4 - Prob. 21PCh. 4 - Refer to Problem 4.21. Complete the trend-adjusted...Ch. 4 - Prob. 23PCh. 4 - The following gives the number of accidents that...Ch. 4 - In the past, Peter Kelles tire dealership in Baton...Ch. 4 - George Kyparisis owns a company that manufactures...Ch. 4 - Attendance at Orlandos newest Disneylike...Ch. 4 - Prob. 28PCh. 4 - The number of disk drives (in millions) made at a...Ch. 4 - Prob. 30PCh. 4 - Emergency calls to the 911 system of Durham, North...Ch. 4 - Using the 911 call data in Problem 4.31, forecast...Ch. 4 - Storrs Cycles has just started selling the new...Ch. 4 - Prob. 35PCh. 4 - Prob. 36PCh. 4 - Prob. 37PCh. 4 - Prob. 38PCh. 4 - Prob. 39PCh. 4 - Prob. 40PCh. 4 - Prob. 41PCh. 4 - Prob. 42PCh. 4 - Mark Gershon, owner of a musical instrument...Ch. 4 - Prob. 44PCh. 4 - Cafe Michigans manager, Gary Stark, suspects that...Ch. 4 - Prob. 46PCh. 4 - The number of auto accidents in Athens, Ohio, is...Ch. 4 - Rhonda Clark, a Slippery Rock, Pennsylvania, real...Ch. 4 - Accountants at the Tucson firm, Larry Youdelman,...Ch. 4 - Prob. 50PCh. 4 - Using the data in Problem 4.30, apply linear...Ch. 4 - Bus and subway ridership for the summer months in...Ch. 4 - Prob. 53PCh. 4 - Dave Fletcher, the general manager of North...Ch. 4 - Prob. 55PCh. 4 - Prob. 56PCh. 4 - Prob. 57PCh. 4 - Sales of tablet computers at Ted Glickmans...Ch. 4 - The following are monthly actual and forecast...Ch. 4 - Prob. 1CSCh. 4 - Prob. 2CSCh. 4 - Prob. 3CSCh. 4 - Prob. 1.1VCCh. 4 - Prob. 1.2VCCh. 4 - Using Perezs multiple-regression model, what would...Ch. 4 - Prob. 1.4VCCh. 4 - Prob. 2.1VCCh. 4 - Prob. 2.2VCCh. 4 - Prob. 2.3VCCh. 4 - Prob. 2.4VCCh. 4 - Prob. 2.5VC
Knowledge Booster
Background pattern image
Operations Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
  • Text book image
    Practical Management Science
    Operations Management
    ISBN:9781337406659
    Author:WINSTON, Wayne L.
    Publisher:Cengage,
    Text book image
    Contemporary Marketing
    Marketing
    ISBN:9780357033777
    Author:Louis E. Boone, David L. Kurtz
    Publisher:Cengage Learning
    Text book image
    Marketing
    Marketing
    ISBN:9780357033791
    Author:Pride, William M
    Publisher:South Western Educational Publishing
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Text book image
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Forecasting 2: Forecasting Types & Qualitative methods; Author: Adapala Academy & IES GS for Exams;https://www.youtube.com/watch?v=npWni9K6Z_g;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License