Director of Supply Chain in Developing Forecasts: Calculate the MAD and MSE
Not what you're looking for?
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.
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.