Please solve the following problems. You can use Ms. Excel or Word. Table 1 presents the actual demands of the past five weeks. Using a = 0.70, calculate the exponential smoothing forecast for week 6. (1 Point) Table 1. The actual demand of the past five weeks Week (t) Actual Demand 1 500 2 450 3 510 4 435 5 435 6 ? Table 1 presents the actual demands of the past five weeks. Let W1 = 0, W2 = 0, W3 = 0.10, W4 = 0.40, and W5 = 0.50 where Wt represent the weight of week t. By using weighted moving average, calculate the forecast for week 6. (1 Point) Table 1 presents the actual demands of the past five weeks. By using 3-period moving average, calculate the forecast for week 6. (1 Point)