Forecast
Not what you're looking for?
The Mayfair Department Store in Davenport, Iowa, is trying to determine the amount of sales lost while it was shut down during July and August because of damage caused by the Mississippi River flood. Sales data for January through June follow.
Month Sales ($1000s)
January 185.72
February 167.84
March 205.11
April 210.36
May 255.57
June 261.19
a) Use exponential smoothing with Alpha = 0.4, to develop a forecast for July and August. (Hint: Use the forecast for July as the actual sales in July in developing the August forecast.) Comment on the use of exponential smoothing for forecasts more than one period into the future.
b) Use trend projection to forecast sales for July and August.
c) Mayfair's insurance company proposed a settlement based on lost sales of $240,000 in July and August. Is this amount fair? If not, what amount would you recommend as a counteroffer?
Purchase this Solution
Solution Summary
This solution is comprised of detailed analysis and step-by-step calculations of various Forecast Techniques like Exponentially Smoothed Forecast, Trend Projection etc. in EXCEL. The solution provides students with a clear perspective of the given problems and the related aspects of forecast analysis.
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Probability Quiz
Some questions on probability
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.