Question: Katie is a waitress at the Princeton Restaurant and works on Thursday, Friday, and Saturday and sunday nights. The following table shows the number of customers that she served during the past twelve nights on her schedule. Use multiplicative decomposition to forecast the number of customers that Katie will serve in Period 12.
|
Period
|
Day
|
Customers
|
Period
|
Day
|
Customers
|
|
Thurs
|
27
|
sat
|
26
|
|
|
|
Fri
|
21
|
sum
|
14
|
|
|
|
Sat
|
26
|
thur
|
14
|
|
|
|
sun
|
22
|
friday
|
30
|
|
|
|
Thurs
|
28
|
Sat
|
10
|
|
|
|
Fri
|
27
|
Sun
|
26
|
|
|
Can you explain how to do this in excel?
What is season indices forecast next two forecast periods What is the mape?
What smooth/deseasalized trend line?