cjpierciiw on 25 May 2007
| NJ5 said: Have you tried doing the same prediction using the last 4 weeks growth or slowdown of sales, and applying the same growth/slowdown to the future? It doesn't make much sense to assume that sales will remain constant. Of course it doesn't make sense that growth/slowdown will remain constant either, but it's probably a closer estimate... |
This sheet does it that way. It doesnt show the exact same sales for each passing week, they are each different. If the sales for the last 4 weeks were all in an uptrend, this sheet would predict in a constantly increasing uptrend. But real world sales fluctuate up and down week to week. Thats why I average it this way so it is not in a constant up or down trend.
