Weighted Average

I've been doing some sales forecasting for next year and needed to do a weighted average on historical data so that I could give stronger emphasis to more recent numbers. An ordinary average may be too high in situations where the oldest number is significantly higher than more recent numbers (due to introduction of a new product, for example).