Operational management: Calculate Sales Forecasts
Not what you're looking for?
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.