Upper management has asked you to join the Demand Planning Project Team. This team has been task with testing three different forecasting algorithm: Simple Exponential Smoothing, Weighted Moving Average and Simple Moving Average. Month 1 2 3 4 5 6 Demand 45 48 42 48 49 54 47 SMA 45 SWMA 45 Part 1. Calculate a forecast for each of the algorithm using the following parameters. (17 Points) Simple Moving Average: calculate the three-period moving-average forecast for periods 4 through 7. Weighted moving average: for periods 4 through 7, using the following weights: wl=.60, w2 = .30, & w3 = 10. Part 2. Determine the best performing forecast from Part 1 based on Mean Absolute Percent Error (MAPE). (17 points)