Question: Do this using excel please, show steps & formulas used please 1. Consider the Double Exponential Smoothing Forecasting Method. Assume S1=1,000,G1=400, alpha =0.1, beta =0.2
Do this using excel please, show steps & formulas used please

1. Consider the Double Exponential Smoothing Forecasting Method. Assume S1=1,000,G1=400, alpha =0.1, beta =0.2 Determine F1,2 (forecast in period 2) = Determine F1,3 (forecast in period 3)= 2. Consider that G1=100 and F0,1 (the forecast for period 1) is 800 . Demand 1 is observed as D1 =900. Then the new slope G2 will be higher than the old slope G1. 3. Briefly describe the type of dataset for which the double exponential smoothing method should be used (i.e., in terms of trend, seasonality, cycles, and randomness)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
