Calculate the forecast for design hour passenger enplanements in the year 2015 using the historical (2006 – 2010) and forecast (2015) data in the table below. Enplaned PassengersYearTotalJanFebMarAprMayJunJulAugSepOctNovDec2005221,67817,86317,87817,94518,05718,16218,96218,95018,93618,83018,70118,74618,6482006223,79518,13818,15318,22018,33218,49319,06019,04819,03418,92818,79918,84418,7462007227,62218,30018,31518,38218,49418,59919,49919,48719,47319,36719,23819,28319,1852008227,74318,19718,21218,27918,39118,69119,56219,55019,53619,43019,30119,34619,2482009228,18518,41618,43118,49818,61018,71519,48019,46819,45419,34819,21919,27519,271Forecast 2015237,678 Questions:Which month is the peak month and percentage of annual enplanements does it represent on average?What is the number of enplaned passengers on an ADPM in 2015?What is the number of enplaned passengers in the design hour in 2015 given that 26.3% of departing seats in the ADPM are provided during that hour.

I am using the 5-period moving average to forecast 2015 monthly data of enplaned passengers.

Answered: Which month is the peak month and…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Calculate the forecast for design hour passenger enplanements in the year 2015 using the historical (2006 – 2010) and forecast (2015) data in the table below.

	Enplaned Passengers
Year	Total	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2005	221,678	17,863	17,878	17,945	18,057	18,162	18,962	18,950	18,936	18,830	18,701	18,746	18,648
2006	223,795	18,138	18,153	18,220	18,332	18,493	19,060	19,048	19,034	18,928	18,799	18,844	18,746
2007	227,622	18,300	18,315	18,382	18,494	18,599	19,499	19,487	19,473	19,367	19,238	19,283	19,185
2008	227,743	18,197	18,212	18,279	18,391	18,691	19,562	19,550	19,536	19,430	19,301	19,346	19,248
2009	228,185	18,416	18,431	18,498	18,610	18,715	19,480	19,468	19,454	19,348	19,219	19,275	19,271
Forecast
2015	237,678

Questions:

Which month is the peak month and percentage of annual enplanements does it represent on average?
What is the number of enplaned passengers on an ADPM in 2015?
What is the number of enplaned passengers in the design hour in 2015 given that 26.3% of departing seats in the ADPM are provided during that hour.

Expert Solution