I have over 800 lines of data. I am trying to create a forecast for each material based on the plant. I have consumption for two years. I want the forecast to be automatic so when someone enters the plant and material, the forecast is auto populated. Currently the issue I am having is how to use Excel to create exponential smoothing for each plant and material combination. Currently the information is in the format below. If there is a formula to do exponential smoothing with seasonality, that will be wonderful.
Plant Material Year Total Jan Feb Mar Apr May Jun Jul Aug Oct Nov Dec
Plant Material Year Total Jan Feb Mar Apr May Jun Jul Aug Oct Nov Dec