Purchase Solution

Forecasting- moving average, exponential smoothing, trend

Not what you're looking for?

Ask Custom Question

MSE(Mean Squared error)
MAD(Mean absolute deviation)

6-23 The Garden Avenue Seven sells tapes of its musical performances. The following data shows sales for the past 18 months. The group's manager wants an accurate method for forecasting future sales.

Month Sales Month Sales Month Sales
1 293 7 381 13 549
2 283 8 431 14 544
3 322 9 424 15 601
4 355 10 433 16 587
5 346 11 470 17 644
6 379 12 481 18 660

Forecast the sales for month 19 and compute the MSE and MAD assuming:
a. A 3 months moving average
b. A 4 months weighted moving average, assuming a weight of 0.4 for the most recent period, 0.3 for the next period back, 0.2 for the third period back, and 0.1 for the fourth period back.
c. An exponential smoothing with alpha = 0.3 and 0.5. Which value of alpha provides the best forecast?
d. A trend line projection
e. Which method of forecasting would you recommend to the manager? Why?

Purchase this Solution
Solution Summary

Makes forecasts using moving average, weighted moving average, exponential smoothing, trend line projection.

Solution Preview

Please see the attached Excel file for answers

Questions:
6-23 The Garden Avenue Seven sells tapes of its musical performances. The following data shows sales for the past 18 months. The group's manager wants an accurate ...

Purchase this Solution
Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

View More Free Quizzes
Related BrainMass Solutions

  • Compariosn of forecasting methods

    78864 Forecasting:"Exponential smoothing", "Moving averages","Weighted moving average","Exponential smoothing with trend", (See attached file for full problem description) Your manager is trying to determine what forecasting method to use.

  • Time series using forecast accuracy and suitability of methods

    The techniques used are: I Naïve (Level) II Naïve (Trend) III Naïve (Season) IV Arithmetic Mean V 6-Month Moving Average VI 12-Month Moving Average VII 6 Month Weighted Moving Average VIII Single Exponential Smoothing IX Linear Trend Exponential

  • Small questions on Forecasting

    Which method provides the best forecast (refer to part A for the moving average and weighted moving average forecast information)? Part D - You have narrowed your forecasting process down to an exponential smoothing method.

  • Exponential smoothing, moving average, trend projection, MAD

    with MAD as the criterion, which of the four forecasting methods is best Please see attached file Uses moving average, trend projection, exponential smoothing for making forecasts.

  • Forecasting methods in Excel

    The solution presents different methods of forecasting in Excel like Moving Average, Exponential smoothing - Holt Winters etc.

  • Development of Appropriate Forecasting Model

    Moving average ( n=3) b. Moving average (n=5) c. Linear trend line d. Exponential smoothing (alpha = .3) e. Exponential smoothing (alpha = .5) f. Exponential smoothing (alpha = .3, beta = .4) g.

  • Smoothing Techniques

    538071 Smoothing Techniques I have been using basic smoothing techniques such as moving average, median smoothing and exponential smoothing to generate forcasts for the time series in the attached excel file.

  • Projecting Monthly Computer Sales

    The is a forecasting problem concerning a company that sells computers. Forecasting methods used are four (4) month moving average, a weighted three-month moving average, linear trend equation, and a simple exponential moving with smoothing constant.

  • MCQs on forecasting methods/techniques

    exponential smoothing B. compound growth rate C. trend analysis D. moving averages 9.

View More Related Solutions