Question

Observed weekly sales of ball peen hammers at the town hardware store over an eight-week period...

Observed weekly sales of ball peen hammers at the town hardware store over an eight-week period have been 14, 9, 30, 22, 34, 12, 19, 23.

a. Suppose that three-week moving averages are used to forecast sales. Determine the one-step-ahead forecasts for weeks 4 through 8.

b. Suppose that exponential smoothing is used with a smoothing constant of alpha = .15. Find the exponential smoothing forecasts for weeks 4 through 8. [To get the method started, use the same forecast for week 4 as you used in part (a).]

c. Based on the MAD, which method did better?

d. What is the exponential smoothing forecast made at the end of week 6 for the sales in week 12?

Homework Answers

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
Sales of paint at Eddie's hardware store over the past 10 weeks are shown below: Week...
Sales of paint at Eddie's hardware store over the past 10 weeks are shown below: Week 1 - 20 Week 2- 21 Week 3- 29 Week 4- 36 Week 5- 24 Week 6- 29 Week 7-37 Week 8- 24 Week 9- 26 Week 10- 29 A. The forecast for week 3 using exponential smoothing with alpha=0.6 and a week 1 initial forecast of 20 is _____ B. For the forecast developed using exponential smoothing with alpha=0.6 and a week 1...
Sales of quit covers at at Jim's departmental store in Australia over the last 12 months...
Sales of quit covers at at Jim's departmental store in Australia over the last 12 months 2017 are shown below Period: Actual Demand: Jan. -20 Feb -21 March -15 April -14 May - 13 June - 16 July - 17 August. - 18 Sep - 20 October. -20 November. - 21 December. -24 Calculate: I. Use a 3- month and 4-month average on all the data and plot averages and the actual demand. II. Using MAD techniques determine which is...
Sales of air conditioners have grown consistently over the years and the follow represents sales: Year          ...
Sales of air conditioners have grown consistently over the years and the follow represents sales: Year           Sales 1                  520 2                  550 3 600 4                  610 5                  680 6                  710 7 810 8 820 9 900 1) The sales manager had predicted, before the business started, that year 1 sales would be 465 air conditioners. Using exponential smoothing with an alpha of .30, develop a forecast. 2) Using smoothing constants of .6 and .9, develop forecasts for the sales of air...
16) Sales of tablet computers at Ted​ Glickman's electronics store in​ Washington, D.C., over the past...
16) 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 20 21 27 38 26 29 37 24 25 29 ​a) The forecast for weeks 2 through 10 using exponential smoothing with alphaα ​= 0.55 and a week 1 initial forecast of 20.0 are ​(round your responses to two decimal​ places): Week 1 2...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 13 7 - Problem 2: Carmen’s decides to forecast auto sales by weighting the three weeks as follows: Weights Applied Period 3 Last week 2 Two weeks ago 1 Three weeks ago 6 Total Problem 3: A firm uses simple exponential smoothing with to forecast demand. The forecast for the week...
A convenience store recently started to carry a new brand of soft drink. Management is interested...
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing​ (let alpha α equals=0.4 with an initial forecast for week 1 of 586​) methods to forecast demand for week 13....
A small business has recorded sales over the last 20 years.  The data is provided in accompanying...
A small business has recorded sales over the last 20 years.  The data is provided in accompanying workbook, tab “Small Business”. The business would like to use this data to provide a sales forecast for the future, specifically, the next two years. Build a spreadsheet that shows all the forecasts on a side-by-side basis so they can be compared for effectiveness using an error measure. Create a chart showing the data in time.  Discuss any patterns in the dat Create moving average...
The monthly sales of a new business software package at a local discount software store were...
The monthly sales of a new business software package at a local discount software store were as follows: Week 1 2 3 4 5 6 7 8 9 10 Sales 480 420 437 450 480 507 470 496 446 476 Find the best number of weeks to use in a moving average forecast based on MSE. Do not round intermediate calculations. Round your answers to two decimal places. Number of weeks MSE 2 3 4 The -Select-2-week3-week4-weekItem 5 moving average...
Problem 3-17 A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales...
Problem 3-17 A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were Day: 1 2 3 4 5 6 7 8 9 Number sold: 32 35 38 37 44 43 41 44 42 Day: 10 11 12 13 14 15 Number sold: 48 43 53 44 50 49 a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 48 for Day...
Question 1: Wendy's Happy Homes Inc. manufactures Home Appliances. Monthly sales of Wendy's Washers and Dryer...
Question 1: Wendy's Happy Homes Inc. manufactures Home Appliances. Monthly sales of Wendy's Washers and Dryer Sets for a nine-month period were as follows: MONTH Washer and Dryer Sales January 490 February 480 March 450 April 500 May 480 June 470 July 490 August 520 September 530 Forecast October sales using: 1) A four-month moving average 2) a six-month moving average 3. Compute the MAD for each forecast method you used. Actual October sales were 520 units. 4) Which method...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT