Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use a 3 - month weighted moving average to forecast the sales for the months June, July, and August. Use weights of ( 1 0

Use a 3-month weighted moving average to forecast the sales for the months June, July, and
August. Use weights of (10),(5), and (1), giving more weight to more recent data. (6.5 pts)
b) Use exponential smoothing with =0.4 to forecast the sales for the months June, July, and
August. Assume that the forecast for May was $39 million. (6.5 pts)
c) Calculate the Mean Absolute Percent Error (MAPE) for each of the two forecasting methods: 3-
month weighted moving average and exponential smoothing, for each month (June, July, and
August). Based on these calculations, identify which method provided a more accurate forecast
for each month. Be sure to show all error measurements. (7 pts)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management Achieving Competitive Advantage

Authors: Jeffrey K. Pinto

4th edition

133798070, 978-0133798074

More Books

Students also viewed these General Management questions

Question

____ I honor other peoples boundaries

Answered: 1 week ago