Please add the following columns in the list that you have attached :
1. Average Monthly Consumption
Issue during Apr15-Mar16/12
2. Procurement Lead Time
Average Time from PO to Receipt
3. Reorder Level
This is the level at which we need to Re-order i.e. when the stock falls to this level, auto-indenting should be done
Please keep on adding list of new items suggested by each department in separate worksheet in the same Workbook and add the same columns as above.
Then we shall sit down and finalize the New Minimum Stock Items list
All departments can provide list of items which they want Stores to maintain minimum stock at all times.
Important criteria is that these items should have regular consumption almost every month or at least once in 2 months.