Question

Given an actual demand this period of 8, a (smoothed) forecast average for this period of...

Given an actual demand this period of 8, a (smoothed) forecast average for this period of 9, and a (smoothed) trend of 4, what is the Forecast Including Trend (FIT) for next period? Use alpha = 0.15 and beta = 0.25. If necessary, round your answer to two (2) decimal places.

Homework Answers

Answer #1

Here,

Demand for the current period, At = 8
Trend, Tt = 4
Average forecast, St = 9
Alpha = 0.15
Beta = 0.25

Step 1: Smoothing the Level of the Series

St+1 = Alpha*At + (1-Alpha)(St + Tt)
St+1 = 0.15*8 + 0.85(9+4) = 12.25

Step 2: Smoothing the Trend

Tt+1 = Beta*(St+1 - St) + (1-Beta)Tt
Tt+1 = 0.25*(12.25-9) + 0.75(4) = 3.81

Step 2: Forecast Including Trend

FIT = St+1 + Tt+1
FIT = 12.25 + 3.81 = 16.06

Therefore the forecast including trend, FIT for the next period is 16.06


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
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 28...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 28 2 30 3 29 4 40 5 43 6 42 7 43 8 45 9 44 10 47 a. Calculate the single exponential smoothing forecast for these data using an α of 0.20 and an initial forecast (F1) of 28. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10 b....
A large Portland manufacturer wants to forecast demand for a piece of​ pollution-control equipment. A review...
A large Portland manufacturer wants to forecast demand for a piece of​ pollution-control equipment. A review of past sales ​(Upper A Subscript tAt​), as shown​ below, indicates that an increasing trend is present.  Smoothing constants are assigned the values of alphaα = 0.20 and betaβ = 0.4 The firm assumes the initial forecast for month 1 ​(Upper F 1F1​) was 11.00 units and the trend over that period Upper T 1T1 was 2.00 units. Using​ trend-adjusted exponential​ smoothing, Forecasts (Upper...
The table below shows the actual demand and the forecasted amounts (where available). Use this table...
The table below shows the actual demand and the forecasted amounts (where available). Use this table to answer questions. Actual Forecast 1 100 - 2 95 - 3 102 - 4 100 105 5 110 111 6 120 115 7 112 115 8 130 125 9 130 128 What is the mean absolute deviation for the forecast? 3.5 2.33 3.89 2.86 What is the mean squared error for the forecast (round to two decimal point)? 89.12 9.94 14.83 4.72 The...
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.
Use a 4-period moving average to forecast next week’s demand for our product. Historical records (oldest...
Use a 4-period moving average to forecast next week’s demand for our product. Historical records (oldest to newest) show 5346, 7812, 6513, 5783, 5982, 6519, 6222, 5577, 6840, 7344 for the past 10 weeks. What effect (smoothing or responsive) would there be if we moved to a 5-period moving average (Hint: calculations are not necessary to answer this question)? Using regression, what will your forecast model be?
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!!!
The following are monthly actual and forecast demand levels for May through December for units of...
The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the D. Bishop Company in Des Moines:    Month Actual Demand Forecast Demand May 108 104 June 80 100 July 112 99 August 112 101 September 105 100 October 106 106 November 125 102 December 115 111 For the given forecast, the tracking signal = ___ MADs (round your response to two decimal places).
Please answer the following questions with actual average sales prices of existing single family homes in...
Please answer the following questions with actual average sales prices of existing single family homes in the United States over a number of years. (10pts) Year Avg Price 1 $114,400 2 $115,300 3 $124,700 4 $126,600 5 $129,300 6 $133,500 7 $135,800 8 $141,800 9 $150,500 10 $159,100 11 $168,300 12 $176,200 13 $185,300 Prepare a line graph of these data. Do the data appear to be stationary or non-stationary? Create a (double) moving average model (with k=2) for the...
Actual demand for a product for the past three months was Three months ago 404 units...
Actual demand for a product for the past three months was Three months ago 404 units Two months ago 355 units Last month 326 units a. Using a simple three-month moving average, make a forecast for this month. (Round your answer to the nearest whole number.) b. If 380 units were actually demanded this month, what would your forecast be for next month, again using a 3-month moving average? (Round your answer to the nearest whole number.) c. Using simple...
The accompanying data file contains 10 observations for t and yt. A 3-period moving average is...
The accompanying data file contains 10 observations for t and yt. A 3-period moving average is plotted along with the actual series. a. Comment on smoothing. The jagged graph represents the original series and the smoother graph represents its 3-period moving average. The smoother graph represents the original series and the jagged graph represents its 3-period moving average. We cannot tell which graph represents the original series and which its 3-period moving average. b-1. Use the 3-period moving average to...