Purchase Solution

Exp smoothing forecast with MAD, RSFE, Tracking signal

Not what you're looking for?

Ask Custom Question

PASSENGER MILES FLOWN ON NORTHEAST AIRLINES, A COMMUTER FIRM SERVING THE BOSTON HUB, ARE AS FOLLOWS FOR THE PAST 12 WEEKS:

ACTUAL PASSENGER ACTUAL PASSENGER
WEEK MILES (1000S) WEEK MILES (1000S)
1 17 7 20
2 21 8 18
3 19 9 22
4 23 10 20
5 18 11 15
6 16 12 22

A)ASSUMING AN INITIAL FORECAST FOR WEEK 1 OF 17000 MILES, USE EXPONENTIAL SMOOTHING TO COMPUTE MILES FOR WEEKS 2 THROUGH 12. USE Ox = 0.2
B) WHAT IS THE MAD FOR THIS MODEL?
C) COMPUTE THE RSFE AND TRACKING SIGNALS. ARE THEY WITHIN ACCEPTABLE LIMITS?

Purchase this Solution
Solution Summary

This posting contains solution to following problem on forecasting for North east airlines.

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.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Balance Sheet

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

View More Free Quizzes
Related BrainMass Solutions

  • Demand Forecasting and Forecasting Error

    Finally, the Tracking Signal (TS = RSFE ÷ MAD) is a measurement that indicates whether the forecast average is keeping pace with any genuine upward or downward changes in demand.

  • Jim's department at a local department store has tracked the

    Forecast demand using exponential smoothing with an alpha of 0.2, and an initial forecast of 28.0. Calculate MAD . What do you recommend from the MAD results?

  • Demand Forecasting and Forecasting Error

    Finally, the Tracking Signal (TS = RSFE ÷ MAD) is a measurement that indicates whether the forecast average is keeping pace with any genuine upward or downward changes in demand.

  • The tracking signal of the st. Louis forecast

    This post determine the tracking signal of the St. Louis forecast.

  • Small questions on Forecasting

    Calculate the mean absolute deviation (MAD) and tracking signal (TS) for each forecast.

  • Choosing the best forecast based on MAD,MAPE,MSE

    , Naïve forecast has very high MAD and MSE values and a smaller value of tracking signal.

  • Seasonal forecasting

    We have only covered the following topics so far: 1) Time series analysis: SimpleMovingAverage, Weightedmovingaverage, Exponential Smoothing 2) Differencing 3) Forecast errors: absolute deviation, mean absolute deviation (MAD), and tracking signal

  • Seasonal Forescasting in Excel

    We have only covered the following topics so far: 1) Time series analysis: SimpleMovingAverage, Weightedmovingaverage, Exponential Smoothing 2) Differencing 3) Forecast errors: absolute deviation, mean absolute deviation (MAD), and tracking signal 4)

  • Exponential smoothing forecast

    354416 Compute an exponential smoothing forecast with a=0.20, an adjusted exponential smoothing forecast with a=0.20 and b=0.20 and a linear trend line forecast.

View More Related Solutions