Purchase Solution

Director of Supply Chain in Developing Forecasts: Calculate the MAD and MSE

Not what you're looking for?

Ask Custom Question

See file attached.

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.

The chart of period and actual quantity to perform the calculations is attached.

Attachments
Purchase this Solution

Solution Summary

The response is a comprehensive view of the problem in Excel and Word information.

Solution Preview

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 based on the 4 ...

Purchase this Solution


Free BrainMass Quizzes
Lean your Process

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

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Basic Social Media Concepts

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

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.