Please show the calculation steps of how you get answer of 499.7 for question (b

Question

Please show the calculation steps of how you get answer of 499.7 for question (b), please calculate by hand not excel

Question 4 (a) (Seasonal Indices) An analyst has been contracted to forecast the number of tourist arrivals in Australia for the June quarter 2008. The information is required for airline scheduling and hotel bookings. The quarterly data for tourist arrivals in Australia from 2004 to 2007 are given below. Tourist Arrivals ('000) Year March June September December After conducting the trend analysis, the analyst obtained the trend estimate for each quarter Year Tourist Arrivals (000) Trend estimate I 2004 1 6207 6113 824 I 6712 6319 321 200s 1 6377 6524 8184 I 6299 6622.566 3 306 21 41 309 2007 1 17315 7346 806 4 7822 7555 Using the above information, calculate by hand the seasonal indices for the Tourist Arrival data and interpret the seasonal indices for the June and December quarters (b) orecast) The following trend line and seasonal indices were calculated from four weeks of daily sales Trend line 200 1.8t Seasonal Effect: Day Seasonal Index (SI) Sunday 1.6 Monday 0.4 Tuesday Wednesday Thursday 1.4 Friday 0.17 Saturday Forecast Saturday's sales values for the next week

Explanation / Answer

For next week t=5

So, Y=200+1.8*5=209

Seasonal index for saturday=1.9

So, Saturday sale value=209+1.9=210.9

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---