If you want to manage your stock requirements in detail:
- Review recent sell rates over n weeks - all based on volume not on $
- Compare to sell rates 1 year and 2 years ago
- Review Promotional impacts on recent sales (separate based on promotion setting)
- Review out of stock situations
- Remove sales orders used to dump stock (flag on sales order - can be set a debtor level to default)
- Adjust sell rates where required
- Review stock levels and dates expected out of stock based on sell rates
- Have system propose purchase orders (by supplier per warehouse)
- Build consolidated purchase orders across multiple warehouses
Start with the sell rates review.
- The raw sales data is calculated every sunday night - ready to be used during the following week. The calculations are all minimum 1 week.
- View any week as a single week to make it easier to adjust sell rates etc.