Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Transcontinental Airlines maintains a computerized forecasting system to forecast the number of customers in each fare class who will fly on each flight in order

Transcontinental Airlines maintains a computerized forecasting system to forecast the number of customers in each fare class who will fly on each flight in order to allocate the available reservations to fare classes properly. For example, consider economy-class customers flying in midweek on the noon flight from New York to Los Angeles. The following table shows the average number of such passengers during each month of the year just completed. The table also shows the seasonal factor that has been assigned to each month based on historical data. Show all formulas and calculations. Month Average Number Seasonal Factor Month Average Number Seasonal Factor January 70 0.9 July 96 1.17 February 73 0.88 August 98 1.15 March 68 0.91 September 82 0.97 April 74 0.93 October 75 0.91 PRDEAPS/2024 May 79 0.96 November 86 1.05 June 87 1.09 December 91 1.08 (a) After considering seasonal effects, compare the MAD values for the last-value method, the averaging method, the moving average method (based on the most recent three months), and the exponential smoothing method (with an initial estimate of 80 and a smoothing constant of 0.2 when they are applied retrospectively to the past year. (15) (b) Use the forecasting method with the smallest MAD value to forecast the average number of these passengers flying in January of the new year. (2) [17]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Analytics Data Analysis and Decision Making

Authors: S. Christian Albright, Wayne L. Winston

5th edition

1133629601, 9781285965529 , 978-1133629603

More Books

Students also viewed these Mathematics questions