Purchase Solution

Operational management: Calculate Sales Forecasts

Not what you're looking for?

Ask Custom Question

3 The following tabulations are actual sales of units for six months and a starting forecast in January.

a. Calculate forecasts for the remaining five months using simple exponential smoothing with α = 0.2.

b. Calculate MAD for the forecasts.
ACTUAL FORECAST
January 100 80
February 94
March 106
April 80
May 68
June 94

Purchase this Solution

Solution Summary

This solution shows step-by-step calculations in an Excel file to determine sale forecast from January to June using simple exponential smoothing. A mean squared error, mean absolute percent error and percent positive errors are also calculated.

Solution Preview

Please see the attached file.

t Month Actual Smoothed Forecast % error
1 January 100 84.0 ...

Purchase this Solution


Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Situational Leadership

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

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.