Inventory Reordering Template
Version: 1.00
Benefits:
Prevent Material Shortage using Reordering Report. By Set up Reorder Point Inventory Level, Reorder Policy, Minimum Order Quantity or Lot Size Quantity.
How to Use:
This Excel template has 2 worksheets:
1 - Set up Reorder Policy
2 - Reorder Report
Worksheet#1 [1 - Set up Reorder Policy]
Step 1 - Entry data only Itemes which have reorder policy ( Item, Reorder Point, Reorder Policy<drop down list>,Qty ).
Worksheet#2 [2 - Reorder Report]
Step 2 - Entry data or import data from your inventory control software ( Item, Item Description, On Hand Qty).
Step 3 - Proposed Reorder Quantity will be calculated automatically from reorder policy.
Want to see more powerful products?
Advance Production Scheduling Template?
Automated Production Scheduling Tool?