red thorn
- A restaurant has tracked the number of meals served at lunch over the last four weeks. The data show little in terms of trends but do display substantial variation by day of the week.
Week
Day 1 2 3 4
Sunday 40 35 39 43
Monday 54 55 51 59
Tuesday 61 60 65 64
Wednesday 72 77 78 69
Thursday 89 80 81 79
Friday 91 90 99 95
Saturday 80 82 81 83
A) Use a trend projection to forecast the total number of meals in Week 5. (10 Points)
B) Based on the previous sales data from table, calculate the seasonality index for day Sunday to Saturday. Now based on these index and demand forecasted in part (A), forecast the demand for Sunday, Monday, and Tuesday of Week 5. (10 Points)
static arrow