Develop a daily forecast using a weighted moving average with weights 0.40, 0.30, 0.20 and 0.10 (most recent to oldest week). 4 weeks of Data with Saturday closed. Is the highest weight allocated to the oldest or recent week? How do you know which weight to use with which week when it says most recent to oldest?
4 Weeks Ago 3 Weeks Ago 2 Weeks Ago Last Week
Mon 2200 2400 2300 2400
Tue 2000 2100 2200 2200
Wed 2300 2400 2300 2500
Thurs 1800 1900 1800 2000
Fri 1900 1800 2100 2000
Sat Closed
Sun 2800 2700 3000 2900