Purchase Solution

Excel: exponential smoothing forecast

Not what you're looking for?

Ask Custom Question

** Please refer to the attached file for the following question **
Develop a forecast for years 2 through 12 using exponential smoothing with ? = .4 and a forecast for year 1 of 6. Plot your new forecast on a graph with the actual data and the naive forecast. Based on a visual inspection, which forecast is better?

Please refer to attachment for details.

Purchase this Solution

Solution Summary

In this solution we use Excel to develop two forecasts based on the given parameters and data and highlights which of these forecasts is better.

Solution Preview

** Please see the attachment for the complete solution **

We have the Exponential smoothing forecast,
Ft = Ft-1 + α (At-1 - Ft-1)
i.e., New ...

Purchase this Solution

Free BrainMass Quizzes
Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

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.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.