Create a weighted moving average model with k=3 for the data set.

Use Solver to determine the optimal values ofthe weights(5 points)

a.

What are the optimal values ofthe weights that minimize MSE

b.

What are MSE and MAPE based on the results from

Day 4 to Day 10 ? (2 points)

c.What is the forecast for Day 11 using this technique?

Please answer the following questions in Word or Excel files. It should be submitted through Canvas with the name: HW Number-Section Number-First Name-Last Name. You will not receive the full credits without the supporting analysis. No late submission will be accepted 1. Please answer the following questions with daily revenues of a store shown in the following table. (15 points) Day Revenue $622 $498 1 2 $608 $712 $588 $656 $689 $675 $706 $705 3 4 5 6 7 8 9 10 (1) Provide a line graph of these data. Do the data appear to be stationary or non- stationary? (2 points) Please answer the following questions in Word or Excel files. It should be submitted through Canvas with the name: HW Number-Section Number-First Name-Last Name. You will not receive the full credits without the supporting analysis. No late submission will be accepted 1. Please answer the following questions with daily revenues of a store shown in the following table. (15 points) Day Revenue $622 $498 1 2 $608 $712 $588 $656 $689 $675 $706 $705 3 4 5 6 7 8 9 10 (1) Provide a line graph of these data. Do the data appear to be stationary or non- stationary? (2 points)