Ok, you've finally submitted your Annual Sales Plan for 2010. Now what?
It's time for forecast accuracy!
In e-commerce activities, I like to evaluate forecast accuracy on a monthly basis. In other words, each of your primary e-commerce micro-channels are evaluated against their forecast each month. You sum all Affiliate demand, and compare it against your forecast. You record the absolute value of your forecast error (-8% and +8% are both reset to 8%).
Repeat this process for all micro-channels (e-mail, paid search, natural search, each catalog you mailed last month). Calculate the absolute average forecast error (8%, 3%, 20%, 4%, 1% = 7.2%).
Your absolute average forecast error should be less than 8%. This is the number you evaluate your forecasting experts against. Each month, your absolute average forecast error should be less than 8%.
Now, here's the good part! After the first month is in the books, you are allowed to adjust your forecasts by advertising micro-channel. In other words, if e-mail marketing exceeded plan by 15%, and you have reason to believe that e-mail marketing will perform at 15% above forecast/plan for the rest of the year, go ahead and adjust your forecast. In subsequent months, you compare your forecasts to the revised forecast.
You'll find that your inventory team and your finance team will LOVE you if you get this part of the job done right!
In fact, you'll become THE person the company looks to, when wanting to know "what the future holds".
This is the best way, in my experience, for a garden variety analyst to gain Executive exposure. Simply own the forecast for where your business is heading, and you'll become an integral part of your Executive team, without having to deal with the pressures of being a real-life Executive.
My football team is the Green Bay Packers. They have to be my team ... I grew up 35 miles from Lambeau Field. My team completed back-...
Look at the first four rows of our life table (values of 0/1/2/3). These are the first 12-15 weeks after a customer buys for the firs...
You probably run Life Tables for your customer file, right? Right? They've been around forever ( click here for a reference f...
If you don't like geeky math, please skip this post, because I am about to show you how the sausage is made! I have eight variables in...