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!!
2014 forecast= 0.3*195+0.7*154=166.3
2015 forecast= 0.3*169+ 0.7*166.3=167.11
answer:
forecast for 2015 is 167.11
Use Exponential smoothing with alpha=0.3 to forecast the sales for 2015 using the data given below...
Use Exponential smoothing with alpha=0.3 to forecast the sales for 2015 using the data given below (Use two decimal points): 2012 194 2013 169 2014 175 ans: _______________
Using exponential smoothing of the data, forecast the sales for the month of July. actual sale: March 1,210 April 1,280, May 1,260 June 1,275 Forecast April 1,240 Alpha 0.20
Question 9 (8 points) Use a simple exponential smoothing model with alpha = .3. The forecast for period 8 is? Use 2 decimal places Per Y
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
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 :)
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
Using the data below, what is the simple exponential smoothing forecast for the 3rd week where a=0.3? Week Time Series Value 2.00 8.00 6.00 3.00 Submit Answer format: Number: Round to: 1 decimal places Based on the data below for chocolate demand per week and using the naive forecasting method, how much you should order for 5th week? Week Time Series Value 15.00 14.00 23.00 6.00 Submit Answer format: Number: Round to: O decimal places.
Given the following data, use exponential smoothing with = 0.3 and α =.5 to develop a demand forecasts for period 7. Assume that the forecast for week 1= 19. Use the Mean Absolute Percent Error to determine which forecasts are more accurate. Period 1 2 3 4 5 6 Demand 17 19 15 19 13 18
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