Spreadsheets: Forecasting Seasonal Data with Excel
Production forecasting with Excel usually entails using straight-line regression. But you'll need to tweak your formulas if you want to incorporate seasonal sales data into the mix. Here's an easy way to run the numbers.
By Bill Jelen | June 29, 2011