Demand for a particular type of battery fluctuates

72) Demand for a particular type of battery fluctuates from one week to the next. A study of the last six
weeks provides the following demands (in dozens): 4, 5, 3, 2, 8, 10 (last week).
(a) Forecast demand for the next week using a two-week moving average.
(b) Forecast demand for the next week using a three-week moving average.
Answer:
Diff: 1
Topic: FORECASTING MODELS — RANDOM VARIATIONS ONLY
AACSB: Analytic Skills
73) Daily high temperatures in the city of Houston for the last week have been: 93, 94, 93, 95, 92, 86, 98
(yesterday).
(a) Forecast the high temperature today using a three-day moving average.
(b) Forecast the high temperature today using a two-day moving average.
(c) Calculate the mean absolute deviation based on a two-day moving average, covering all days in which
you can have a forecast and an actual temperature.
Answer:
Diff: 2
Topic: VARIOUS
AACSB: Analytic Skills

16
74) For the data below:
Month
Automobile
Battery Sales
Month
Automobile
Battery Sales
January 20 July
February 21 August
March 15 September
April 14 October
May 13 November
June 16 December
(a) Develop a scatter diagram.
(b) Develop a three-month moving average.
(c) Compute MAD.
17
18
20
20
21
23

Answer:
-
-
-
2
3
-
Diff: 3
17
Topic: VARIOUS
AACSB: Analytic Skills

18
75) For the data below:
Month
Automobile
Tire Sales
Month
Automobile
Tire Sales
January 80 July
February 84 August
March 60 September
April 56 October
May 52 November
June 64 December
(a) Develop a scatter diagram.
(b) Compute a three-month moving average.
(c) Compute the MSE.
68
100
80
80
84
92

Answer:
-
-
-
64
Diff: 3
19
Topic: VARIOUS
AACSB: Analytic Skills

20
76) For the data below:
Year Automobile Sales Year Automobile Sales
1990 116 1997
1991 105 1998
1992 29 1999
1993 59 2000
1994 108 2001
1995 94 2002
1996 27 2003
(a) Develop a scatter diagram.
(b) Develop a six-year moving average forecast.
(c) Find MAPE.
119
34
34
48
53
65
111

Answer:
Actual
X
X
X
X
X
X
2.15
0.41
1.14
1.16
0.44
0.12
0.19
0.47
Diff: 3
21
Topic: VARIOUS
AACSB: Analytic Skills

22