Question

Consider the accompanying time series. a. Forecast the demand for each quarter in Year 4 using...

Consider the accompanying time series.

a. Forecast the demand for each quarter in Year 4 using multiplicative decomposition.

b. Interpret the meaning of the seasonal components.

c. Calculate the MAD for this forecast.

Year_1_Quarter   Year_ 1_Demand   Year_2_Quarter   Year_2_Demand   Year_3_Quarter   Year_3_Demand
1 4 1 5 1 8
2 10 2 13 2 16
3 11    3 11 3 14
4 5 4 9 4    8

.

Homework Answers

Answer #1

The MINITAB output is:

Method

Model type Multiplicative Model
Data Demand
Length 12
NMissing 0

Fitted Trend Equation

Yt = 5.46 + 0.593×t

Seasonal Indices

Period Index
1 0.67690
2 1.47660
3 1.33477
4 0.51174

Accuracy Measures

MAPE 12.2786
MAD 0.9778
MSD 1.3145

Forecasts

Period Forecast
13 8.9099
14 20.3116
15 19.1519
16 7.6460

a. Forecast the demand for each quarter in Year 4 using multiplicative decomposition.

Forecasts

Period Forecast
13 8.9099
14 20.3116
15 19.1519
16 7.6460

b. Interpret the meaning of the seasonal components.

Quarter 2 has the highest demand, followed by Quarter 3, followed by Quarter 1 and then by Quarter 4.

c. Calculate the MAD for this forecast.

MAD 0.9778
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Consider the following time series. Period   Demand 1   6 2   7 3   5 4   9 5  ...
Consider the following time series. Period   Demand 1   6 2   7 3   5 4   9 5   13 6   16 7   12 8   16 ​a) Using a trend​ projection, forecast the demand for Period 9. ​a) The forecasted demand for Period 9 is ​(Type an integer or decimal rounded to one decimal place as​ needed.) ​b) Calculate the MAD for this forecast. ​b) MAD= ​(Type an integer or decimal rounded to one decimal place as​ needed.)
Consider the following time series data (Insert the data in an Excel file): Quarter Year 1...
Consider the following time series data (Insert the data in an Excel file): Quarter Year 1 Year 2 Year 3 1 8 9 12 2 5 6 9 3 7 8 10 4 8 11 11 2.1. Construct a time series plot. What type of pattern exists in the data? 2.2. Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1=1 if quarter 1, 0 otherwise; Qtr2=1...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62 2 48 40 50 3 59 61 54 4 78 81 72 (a) Construct a time series plot. What type of pattern exists in the data? a)The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. b)The time series plot shows a horizontal pattern with no seasonal pattern present.     c)The time series plot shows a trend...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62 2 50 42 52 3 59 61 54 4 78 81 72 (a) Construct a time series plot.    What type of pattern exists in the data? The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. The time series plot shows a trend pattern, but there is also a seasonal pattern in the data.     The...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your answers...
Consider the following: period 1, 2, 3, 4, 5, 6, 7, 8 demand 7, 8, 9,...
Consider the following: period 1, 2, 3, 4, 5, 6, 7, 8 demand 7, 8, 9, 10, 14, 16, 13, 16 a. using a trend projection, forecast the demand for period 9 b. calculate the MAD for this forecast Show all work! do not use excel or phstat!!!
Consider the following time series. Given: Period:1,2,3,4,5,6,7,8 Demand: 7,9,8, 10,13,14,12,15 a) Using a trend projection, forecast...
Consider the following time series. Given: Period:1,2,3,4,5,6,7,8 Demand: 7,9,8, 10,13,14,12,15 a) Using a trend projection, forecast the demand for Period 9. b) Calculate the MAD for this forecast.
Examine the following quarterly data. After calculating the seasonal index for each quarter. Deseasonalize the time...
Examine the following quarterly data. After calculating the seasonal index for each quarter. Deseasonalize the time series. Produce the trend line using the deseasonalized data. t yt Quarter 1 1 5 Quarter 2 2 3 Quarter 3 3 11 Quarter 4 4 26 Quarter 1 5 21 Quarter 2 6 19 Quarter 3 7 31 Quarter 4 8 51 Quarter 1 9 42 Quarter 2 10 36 Quarter 3 11 51 Quarter 4 12 82 A) Produce seasonally adjusted forecasts...
1. Consider the following time series data. t 1 2 3 4 5 Yt 6 11...
1. Consider the following time series data. t 1 2 3 4 5 Yt 6 11 9 14 15 a. Develop the linear trend equation for this time series (to 1 decimal). Tt = (___) + (___) t b. What is the forecast for t=6 (to 1 decimal)? (___) 2. Consider the following time series data. t 1 2 3 4 5 Yt 7 11 9 14 16 a. Develop the linear trend equation for this time series (to 1...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62 2 49 41 51 3 57 59 52 4 78 81 72 (a) Use the following dummy variables to develop an estimated regression equation to account for seasonal effects in the data: x1 = 1 if quarter 1, 0 otherwise; x2 = 1 if quarter 2, 0 otherwise; x3 = 1 if quarter 3, 0 otherwise. = _____?______ (b) Compute the quarterly forecasts for...