Show in Excel steps

For Part 1 and 2, using the following demand data over two years and a total of eight quarters. Period Year. Demand Level Lt It Quarter D Assume Trend Forecast TE Ft Lo-220 2 4 Year 1, 225 01 Year 1, 174 Q2 Year 1, 241 Q3 Year 1, 727 04 Year 2, 01 Year 2 16 Q2 Year 2, 7 Q3 Year 2. 18 03 Part 1: Simple Exponential Smoothing (a = 0.4) 5 1. Estimate level component (L.) for periods 1-4. 2. Forecast demand (F) for periods 1-4. 3. Forecast demand (F) for periods 5-8. For Part 1 and 2, using the following demand data over two years and a total of eight quarters. Period Year. Demand Level Lt It Quarter D Assume Trend Forecast TE Ft Lo-220 2 4 Year 1, 225 01 Year 1, 174 Q2 Year 1, 241 Q3 Year 1, 727 04 Year 2, 01 Year 2 16 Q2 Year 2, 7 Q3 Year 2. 18 03 Part 1: Simple Exponential Smoothing (a = 0.4) 5 1. Estimate level component (L.) for periods 1-4. 2. Forecast demand (F) for periods 1-4. 3. Forecast demand (F) for periods 5-8