Case STudy Excel work.xlsx - CASE PROBLEM FORECASTING...

This preview shows page 1 - 6 out of 17 pages.

CASE PROBLEM - FORECASTING AIRPORT PASSENGER ARRIVALSDay4-6 AM6-8 AM8-10 AM10-noonnoon-2 PM12400270032001400170021900250031001600180032300310025001500150042200320031002200190052400330034001700220016260028003500150017007190028003100120015008200027002500150020009240032003600160021001026003300310020025001131003900410022002600122800340039001900210013270038004300210024001424003500410024003000215330037004000260026001635004000380023002700172900410039002400300018340038004200200025001936003600400023002600203700370040002200260021440044004500260033002242004500430025003400234500450047002700340024460046004600250032003254500430044002900330026420043004500300040002745004500510033004000284300420043002800350029490041004200310036003047004500410030004000316Total9890011100011610065200807000.1460.1640.1710.0960.1194470.655017.615248.152947.283647.94Seasonal FactorDaily Seasonal forecast
4926.5015529.2385783.2843247.8054019.905Annual Average demand forecast
2-4 PM4-6 PM6-8 PM8-10 PMTotalDaily forecast180016008002001580015053.33200018009003001590015571.951800190011002001590016090.572400210012004001870016609.202100200010006001870017127.821900150011003001690017646.44200014009004001520018165.062300190010002001610018683.682500180014002001880019202.302600240011004001820019720.922300250011003002210020239.542500200012003002010020758.162400240012004002170021276.783200260012007002310021795.402700290010003002310022314.02310030009002002350022832.643200250011005002360023351.263000220010003002240023869.892800260012002002290024388.512700240012002002270024907.133400300012004002720025425.753600310014003002730025944.373500290012003002770026462.993500280013003002740026981.613300330015004002790027500.233400300015006002850028018.853700310012003002970028537.474000330011004002790029056.093900340014005002910029574.713700340012005002910030093.3330611.95853007480034600106006772000.1260.1100.0510.0161.0003855.883381.241564.05479.1630611.95
4249.0453726.0091723.528528.01733733.333
Model 1Absolute errorDaily demand forecasr746.67Intercept(a) 14534.71328.05Slope(b)518.6207190.57Forecast(y(4))30611.952090.801572.18Correlation (R)0.958722746.44R20.9191482965.062583.68402.301520.92Daily forecast1860.46MAD1162.54658.16MAPD0.04984.87%423.221304.60785.98667.36248.741469.891488.512207.131774.251355.631237.01418.39399.77481.151162.531156.09474.71993.3333713.56168000170000172000

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture