1. Business
  2. Operations Management
  3. question 14 a festival runs for nine days and has...

Question: question 14 a festival runs for nine days and has...

Question details

Question 14:

  1. A festival runs for nine days and has different attractions and promotions on each of the nine days. Attendance data has been kept for the last five years, and is provided on the ‘Festival’ worksheet.

    Management has noticed that certain days consistently have higher attendance than others, and is proposing to use the multiplicative seasonality methodology to forecast attendance for each day in the coming year.   Please build them a multiplicative seasonal model in Excel to answer the questions below.

    Hint 1 - be careful when you are presented with data in a different format then you may have seen before - in this case the data will be organized a little differently than it was in the lab. A part of your challenge is to identify the "seasons" (they may be listed vertically down the side of the table, or may be listed horizontally across the top of the table); this will determine whether you calculate seasonal indexes relative to each other in rows or in columns.

    Hint 2 - copy the table and paste it into new cells, and in the new cells delete all of the numbers inside (leaving only the vertical and horizontal headings). It is in the table that you can calculate all of the individual seasonal indexes.

    (*Please answer to two decimals, and include only the number in your answer).

    What is the seasonal index for Day 5 in Year Four?

    What is the average seasonal index (over the five years) for Day Seven?

    If total attendance for year six is forecast to be 8,800, then what is the forecast for attendance on Day Two of Year Six?

QUESTION 14 A festival runs for nine days and has different attractions and promotions on each of the nine days. Attendance data has been kept for the last five years, and is provided on the Festival worksheet Management has noticed that certain days consistently have higher attendance than others, and is proposing to use the multiplicative seasonality methodology to forecast attendance for each day in the coming year. Please build them a multiplicative seasonal model in Excel to answer the questions below Hint 1 - be careful when you are presented with data in a different format then you may have seen before - in this case the data will be organized a little differently than it was in the lab. A part of your challenge is to identify the seasons (they may be listed vertically down the side of the table, or may be listed horizontally across the top of the table); this will determine whether you calculate seasonal indexes relative to each other in rows or in columns Hint 2 - copy the table and paste it into new cells, and in the new cells delete all of the numbers inside (leaving only the vertical and horizontal headings). It is in the table that you can calculate all of the individual seasonal indexes (Please answer to two decimals, and include only the number in your answer) What is the seasonal index for Day 5 in Year Four? What is the average seasonal index (over the five years) for Day Seven? If total attendance for year six is forecast to be 8,800, then what is the forecast for attendance on Day Two of Year Six?

L8 Festival Attendance by Day Day1 Day2 Day3 Day4 Day5 Day61095 Day7 Day8 Day9 Year1 763 825 808 856 947 Year2 805 924 805 870 949 1182 1197 1143 Year3 849 882 737 952 1041 1276 1130 1103 842 Year4 829 957 788 858 1010 1297 1093 1020 880 Year5 798 989 782 767 932 1316 1040 1041 821 6 10 1155 1203 793 12 13 14 15 16 17 18 19 20 21 23 24 25 26 27 28 29 30 31 32 FestivalAttendance

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution