Free Essay

Problem -Given Is a Historical Time Series for Job

In:

Submitted By arnitaetsitty
Words 571
Pages 3
Problem -Given is a historical time series for job
Click Link Below To Buy: http://hwaid.com/shop/problem-given-historical-time-series-job/ 1. Given is a historical time series for job services demand in the prior 6 months. Month Demand
1 799
2 816
3 789
4 814
5 815
6 805
2.
Use the table below to answer all questions: Month Demand Forecast
1 799 F1
2 816 F2
3 789 F3
4 814 F4
5 815 F5
6 805 F6
7 F7
3.
a) The F3 by using Naïve forecasting method = _________
b) The F7 by using Naïve forecasting method = _________

2
1. Given is a historical time series for job services demand. Period Demand Forecast
1 313 F1
2 289 F2
3 208 F3
4 325 F4
5 219 F5
6 323 F6
7 302 F7
8 299 F8 F9 F10 F11 F12
2.
If you were not able to generate a forecast for particular period, you should enter N. Also, F3 means Period 3 Forecast. Use Weighted moving average with weights of 0.09, 0.11, 0.16, 0.25, 0.39 to answer Questions 1) to 3).
1) The F5 = ______
2) The F12 = ______ (in two decimal places)
3) If you were told to prepare a forecast schedule, the forecast schedule should contain forecast demands from Period ______ to Period ______. Use Exponential Smoothing with alpha = 0.29 to answer Questions 4) to 6)
4) The F2 = ______ (in two decimal places)
5) The F3 = ______ (in two decimal places)
6) If you were told to prepare a forecast schedule, the forecast schedule should contain forecast demands from Period ______ to Period ______.

3
1. National Scan, Inc., sells ratio frequency inventory tags. Monthly sales for a 6-month period were as follows:

Month: Sales
Feb 65
Mar 66
Apr 66
May 71
Jun 72
Jul 72
2.
Disregard the demand pattern of the given time series, You are asked to use the time series to derive a trend equation. In order to derive the trend equation is Ft = a + bt, you have to compute several components to compute the values for the variables a and b. Answer the following questions pertaining to information that are relevant to deriving the trend equation.

a) The Σty = ______ b) The Σy = ______

c) The value for the b (slope of the trend line) = ______ (in 3 decimal places)

d) The value for the a (intercept of the trend line) = ______ (in 3 decimal places)

4.

1. Given is a historical time series for job services demand in the prior 6 months. Month Demand
1 13
2 16
3 12
4 18
5 20
6 17
2.
a) The MAD based on the Exponential smoothing α = 0.2 method = ____ (4 decimal places). b) The MAD based on the 3 months moving average method = ____ (in 4 decimal places). c) The MSE based on the 3 months moving average method = ____.

d) Use MAD as an criterion to evaluate forecasting methods I (exponential smoothing, α = 0.2 ) and II (3 month moving average). The most accurate forecasting methods between I and II is method = ____ (select to type in as I or II).

e) Month 4 Forecast based on the Exponential smoothing α = 0.2 method = _____ (4 decimal places). f) Month 6 Forecast based on 3 months moving average method = _____ (4 decimal places).