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 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...
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...
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...
As Operations Manager for the same medical device manufacturer you have fresh order data for a hip replacement assembly called HIP 2. Based on the order data below, choose the best possible forecast method: Week HIP 2 1 23 2 21 3 25 4 33 5 27 6 28 7 28 8 36 9 30 10 31 11 30 12 40 13 33 14 34 A. Linear Trend B. Moving Average C. Exponential Smoothing D. Weighted Moving Average
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...
Consider the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week Sales (1,000s of gallons) 1 17 2 21 3 16 4 24 5 17 6 18 7 22 8 20 9 21 10 19 11 16 12 25 (a) Show the exponential smoothing forecasts using α = 0.1, and α = 0.2. Exponential Smoothing Week α = 0.1 α = 0.2 13 (b) Applying the MSE measure of forecast accuracy, would you prefer a...