2. Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows: SALES ($1,000s) 11 14 16 10 15 17 11 MONTH SALES ($1,000s) January February March April May June July 14 17 12 14 16 11 MONTH August September October November December January a) Using a moving average with three periods, determine the demand for vacuum cleaners for next February. b) Using a weighted moving average with three periods, determine the demand for vacuum cleaners for February. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively. For example, if you were forecasting the demand for February, November would have a weight of 1, December would have a weight of 2, and January would have a weight of 3. c) Evaluate the accuracy of each of these methods.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 23PPS
icon
Related questions
Question
100%
2. Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows:
SALES ($1,000s)
11
14
16
10
15
17
11
MONTH SALES ($1,000s)
January
February
March
April
May
June
July
14
17
12
14
16
11
MONTH
August
September
October
November
December
January
a) Using a moving average with three periods, determine the demand for vacuum cleaners for next
February.
b) Using a weighted moving average with three periods, determine the demand for vacuum cleaners
for February. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most
recent periods, respectively. For example, if you were forecasting the demand for February,
November would have a weight of 1, December would have a weight of 2, and January would have
a weight of 3.
c)
Evaluate the accuracy of each of these methods.
d) What other factors might R. Lowenthal consider in forecasting sales?
Transcribed Image Text:2. Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows: SALES ($1,000s) 11 14 16 10 15 17 11 MONTH SALES ($1,000s) January February March April May June July 14 17 12 14 16 11 MONTH August September October November December January a) Using a moving average with three periods, determine the demand for vacuum cleaners for next February. b) Using a weighted moving average with three periods, determine the demand for vacuum cleaners for February. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively. For example, if you were forecasting the demand for February, November would have a weight of 1, December would have a weight of 2, and January would have a weight of 3. c) Evaluate the accuracy of each of these methods. d) What other factors might R. Lowenthal consider in forecasting sales?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,