Perishable Item Complex Forecasting

Table of Contents

Overview

If you want to manage your stock requirements in detail:

1. Review recent sell rates over n weeks - all based on volume not on $
2. Compare to sell rates 1 year and 2 years ago
3. Review Promotional impacts on recent sales (separate based on promotion setting)
4. Review out of stock situations
5. Remove sales orders used to dump stock (flag on sales order - can be set a debtor level to default)
6. Adjust sell rates where required due to expected fluctuations (sporting event for example)
7. Review stock levels and dates expected out of stock based on sell rates
8. Have system propose purchase orders (by supplier per warehouse)
9. Build consolidated purchase orders across multiple warehouses

Forecasting View

Start with the sell rates review.

1. The raw sales data is calculated every sunday night - ready to be used during the following week.  The calculations are all minimum 1 week.
2. View any week as a single week to make it easier to adjust sell rates etc.