Please answer the following:
A pizza chain has had sales for take-out food over the last four evenings-Monday, Tuesday, Wednesday, and Thursday-of 29, 25, 35, and 30 pizzas, respectively. What would be their forecast for Friday using an exponential smoothing forecasting approach? Use α = 0.2 and a forecast for Monday of 28.
** My text book gives the answer, but does not show step by step how they arrive at that answer, and I keep getting a different answer** Please show the work in excel, so I can understand. Thanks!