Question: Consider the sales data for Bell, Inc. given in Problem 2. a. Use a three-month weighted moving average to forecast the sales for the months

Consider the sales data for Bell, Inc. given in Problem 2.
Consider the sales data for Bell, Inc. given in Problem

a. Use a three-month weighted moving average to forecast the sales for the months April through December. Use weights of (3/6), (2/6), and (1/6), giving more weight to more recent data.
b. Use exponential smoothing with α = 0.30 to forecast the sales for the months April through December. The forecast for January was $12 million.
c. Compare the performance of the two methods by using the bias and MAD as the performance criteria. Which performance method is the most reasonable? Why?

SALES ($ MILLIONS) 26 31 27 18 16 SALES ($MILLIONS MONTH MONTH January February March April May June 10 12 14 16 18 23 July August September October November December

Step by Step Solution

3.39 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a 3month weighted moving average forecast for month 4 Demand for month 116 Demand for month 226 Dema... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

852-B-M-L-S-C-M (4390).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!