Purchase Solution

Director of Supply Chain is developing forecasts: moving average, smoothing factor

Not what you're looking for?

Ask Custom Question

Your Director of Supply Chain needs help in developing forecasts. Choose one of the following three options.

Develop forecasts for periods 6 through 24 using MA with 3 periods, 4 periods, and 5 periods, or...

Develop forecasts for periods 3 through 24 using a smoothing factor of 0.2 and 0.3, or...

Develop forecasts for periods 5 through 24 using weighted moving average with weights of 0.4, 0.3, 0.2, and 0.1.

Calculate the MAD and MSE for all of your forecasts. Start MAD and MSE calculations for moving averages in period 6. Start MAD and MSE calculations for exponential smoothing in period 5. Start MAD and MSE calculations for Weighted Averages in period 5.

Attachments
Purchase this Solution

Solution Summary

The solution carefully explains how to construct a moving average, a weighted moving average, and a forecast using a smoothing factor.

Solution Preview

See attached files.

My response used the weighted moving average.

(Column C)
Create the forecast by multiplying the previous value by .4, the one before that by .3, before that .2 and before that .1. Each period's forecast will be ...

Purchase this Solution


Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.