Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 28 36 26 29 35 20 25 30 a) The forecast for weeks 2 through 10 using exponential smoothing with alpha = 0.55 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places): Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 28 36 26 29 35 20 25 30 Forecast 21.0
Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10...
Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 19 21 28 38 26 30 36 24 25 30 a) The forecast for weeks 2 through 10 using exponential smoothing with alpha = 0.55 and a week 1 initial forecast of 19.0 are (round your responses to two decimal places): Week 1 2 3...
Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in thetable below: Week 1 2 3 4 5 6 7 8 9 10 Demand 19 20 29 38 26 28 37 24 25 30 Forecast 19.0 a) The forecast for weeks 2 through 10 using exponential smoothing with alpha = 0.50 and a week 1 initial forecast of 19.0 are (round your responses to two decimal places):
Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 19 21 28 38 26 30 36 24 25 30 a) The forecast for weeks 2 through 10 using exponential smoothing with alpha = 0.55 and a week 1 initial forecast of 19.0 are (round your responses to two decimal places): Week 1 2 3...
Jim's department at a local department store has tracked the sales of a product over the last ten weeks. Forecast demand using exponential smoothing with an alpha of 0.4, and an initial forecast of 25.0 for period 1. Calculate the MAD covering periods 1-10. Calculate the tracking signal covering periods 1-10. What do you recommend? Period Demand 1 24 2 23 3 26 4 37 5 26 6 30 7 32 8 27 9 25 10 28
Orchard Relief is a product that is designed to improve sleep at night. The company, Eli Orchard, is guessing that sales of the product is somewhat related to sleeping patterns of customers over the days of the week. Before mass production of the product, Eli Orchid has market-tested Orchid Relief in only Orange County over the past 8 weeks. The weekly demand is recorded. Eli Orchid is now trying to use the sales pattern over the past 8 weeks to...
2. (20 points) The following table shows the monthly sales in a local grocery store Month and 120 115 125 119 127 114 114 120 124 116 137 10 a. Suppose that Three-weeks moving average are used to forecast sales. Determine the one-step-ahead forecasts for weeks 4 through 10. b. Suppose that exponential smoothing is used with a smoothing constant α-02. Find the exponential smoothing forecasts weeks 4 through 10. (To get the method started, use 120.00 as the forecast...
8. The table below shows the past 10 weeks of actual sales (y) and forecast sales for the next period (Øt+1): Forecast for Week Sales next period 400 400 430 420 440 460 406 408.80 415.04 424.03 427.23 435.78 434.62 440 470 430 435.70 9 440 420 432.56 10 If the actual sales for week 11 were 410, what would the Exponential Smoothing model predict for the sales in week 12 for a=0.20? Page 19 of 20
11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table summarizes the number of new cars sold during each of the past 12 weeks: (PLEASE ANSWER BY USING EXCEL) week number sold 1 22 2 26 3 23 4 27 5 21 6 25 7 28 8 26 9 29 10 29 11 27 12 31 (a) Provide a forecast by using a 3-week weighted moving average technique with weights...
Registration numbers for an accounting seminar over the past 10 weeks are shown below: Week 1 2 3 4 5 6 7 8 Registration 22 21 25 27 35 29 33 37 Forecast registration for weeks 5 thru 8 using a 3-week moving average? Forecast registrations weeks 5-8 using a 3-week weighted moving average with weights of .5 , .3 , and 2. with the most weight going to the most recent data? which forecasts are more accurate using MAD?...
Ch8-A For data of weekly returns (in %) of Google stock given here, forecast the return for the week of March 5, 2017 as follows. [Note: Express your forecasts in % rounded to to 2 decimal places (eg, 3.23%), and express the MSE's and MAE rounded to 5 decimal places (e.g., 0.00073).] (a) Use a 3-week moving average and find the MSE and MAE. (b) Use exponential smoothing with alpha value 0.3 and compute the error measures (c) Now using...