So I need to forecast sales and have no idea how to even begin..?
The dataset contains weekly sales for both Pepsi 12 pack and 2 liter, their corresponding prices, dummy variables = 1 if there was a promotion that week, 0 otherwise, Coke prices and promotions, and dummy variables representing season and holidays. Also has means and standard deviations.
I need to provide forecast equations for both Pepsi 12 pack and 2 liter. I must have the lowest MAD, mean absolute deviation, across successive 4 week periods possible.
HOW do I get the lowest MAD - beyond by depth here - please help/explain a possible approach.