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
Answer #1
Not the answer you're looking for?
Similar Questions
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
tablebelow:
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...
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in...
Suppose these data show the number of gallons of gasoline sold
by a gasoline distributor in Bennington, Vermont, over the past 12
weeks.
Week
Sales (1,000s
of gallons)
1
21
2
25
3
23
4
27
5
22
6
20
7
24
8
22
9
26
10
24
11
19
12
26
Show the exponential smoothing forecasts using α = 0.1.
(Round your answers to two decimal places.)
Week
Time Series
Value
Forecast
1
21
2
25
3
23
4...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 13 minutes ago
asked 18 minutes ago
asked 21 minutes ago
asked 28 minutes ago
asked 41 minutes ago
asked 41 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago