Purchase Solution

Operations Management

Not what you're looking for?

Ask Custom Question

1. Explain exponential smoothing and what the MAD and MSE scores mean in the attached spreadsheet.

The original assignment was as follows.
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.
Just need help with Item 1.

Purchase this Solution

Solution Summary

The solution answers the question below in great detail.

Solution Preview

In statistics, exponential smoothing refers to a particular type of moving average technique applied to time series data, either to produce smoothed data for presentation, or to make forecasts. The time series data themselves are a sequence of observations. The observed phenomenon may be an ...

Purchase this Solution


Free BrainMass Quizzes
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.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.