If you want to 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 settingseparates sales related to promotions)
- Review current and expected out of stock situations including expiry dates and minimum shelf life considerations.
- Remove sales orders used to dump stock (Do not include flag on sales order - can be set a at debtor level to default on)
- Adjust sell rates where required due to expected fluctuations (sporting event for example)
- Review stock levels and dates expected out of stock based on adjusted sell rates
- Have system propose purchase orders (by supplier per warehouse) with qty and eta respecting supplier regular order cycles
- 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.
See Product Forecasting Based on Sales History for details