Forecaster.xls is a Purchase Order Generator for Excel users. To generate a purchase order, the user inputs his current onhand counts, the program computes the speed of each SKU in pieces sold per day, forecasts how many pieces will be sold during the planning horizon, subtracts the current onhand count to get a suggested order quantity rounded to the full case and bounded by min/max constraints. SKU speeds are retained for 3 years to maximize forecast accuracy during trend and seasonality. Open source code. See ExcelMacros.com.
