Question 9 (8 points) Use a simple exponential smoothing model with alpha = .3. The forecast...
Question 7 (1 point) The Simple Exponential Smoothing (SES) forecast with an alpha of .25 for period 4 is: (round to 2 decimal places) Absolute Absolute Percent Error Squared Error Error 9 Naive X(Period) Y/Sales) Forecast Error 11 2. 12 8 3 4 10 5 15 12 기 Your Answer: Answer Question 8 (1 point) At what quantity is selling either of the products equally profitable (point of indifference i.e. crossover point)? Product 1 Product 2 68 53 26 Price/Unit...
Use Solver to determine the alpha that minimizes the MAD for the exponential smoothing forecast for the data that appear in this table. Use the actual demand of period 1 as the forecast for period 2 and then use the forecasts for periods 2 through 9 to calculate MAD. Period Demand 1 272 2 278 3 269 4 280 5 267 6 258 7 278 8 298 9 286 10 290 0.43 0.36 0.54 0.62
Use Solver to determine the alpha that minimizes the MSE for the exponential smoothing forecast for the data that appear in this table. Use the actual demand of period 1 as the forecast for period 2 and then use the forecasts for periods 2 through 9 to calculate MSE. Period Demand 1 272 2 278 3 269 4 280 5 267 6 258 7 278 8 298 9 286 10 290 0.66 0.39 0.57 0.48
Question 6 3 pts Consider the following simple exponential smoothing model. alpha 0.05 Exp Smooth Period Demand ForecastError ABS(Error) 19 21 28 25 30 1 20.00 20.40 20.63 21.10 8.00 4.60 9.37 11.90 8.00 4.60 9.37 11.90 4 What is the forecast for period 10?
Question 11 (10 points) a) For the following demand data, use exponential smoothing with alpha = 0.2 to calculate a forecast for period 7. Assume the forecast for period #1 was 7.0. b) Calculate the MAD error for periods 1-6 for your forecast Period Demand 1 10
In Excel, create a forecast for periods 6-13 using the following method: Exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); With exponential smoothing, the forecast for period 13 will be: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74 Thank you :)
Predict Inc., is using a simple exponential smoothing model to forecast their monthly sales but they are not sure of the best alpha value to use. They ran some computerized forecasts with different alpha values and reported the following. What alpha value should they use? alpha 0.15 0.20 0.25 0.30 0.35 0.40 0.45 0.50 MAD 18.4 14.7 13.2 16.2 15.3 11.7 10.2 12.5 Group of answer choices 0.45 0.15 0.2 0.35 0.5
Given the following data, use exponential smoothing (α=0.2) to develop a demand forecast. Assume the forecast for the initial period is 5. Period Demand 4 5 7 913 8 The exponential smoothing forecast is (round your responses to two decimal places): Period 3 刄 7 Forecast 5.00
Use Exponential smoothing with alpha=0.3 to forecast the sales for 2015 using the data given below (Use two decimal points): 2012 154 2013 195 2014 169 I HAVE 8 MINUTES TO ANSWER THIS PLEASE!!
A) for the following demand data, use exponential smoothing with alpha = .02 to calculate for perieod 7 assume forecast for period #1 was 7.0 B) Calculate the MAD error for periods 1-6 for your forecast period demand 1 10 2 8 3 7 4 10 5 12 6 9