Inventory Reorder Report

This report will go through the inventory file and determine any reorders that should be done.

 

 

Report Date   MM/DD/YY                   Inventory Reorder Report                   PAGE     1

 

    Item #          Description     Vendr Class On Hand Commited Avg Sales  Time  On POs  Order

------------ ---------------------- ----- ----- ------- -------- --------- ------ ------ -------

XXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX XXXXX XXXXX ####### ######## ######.## ###### ####### ######

XXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX XXXXX XXXXX ####### ######## ######.## ###### ####### ######

XXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX XXXXX XXXXX ####### ######## ######.## ###### ####### ######

XXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX XXXXX XXXXX ####### ######## ######.## ###### ####### ######

 

 

Column

Description

Point

is the Reorder Point

On Hand

is the Total Quantity On Hand

Commited

is the Quantity Committed to Customer Orders

Avg Sales

is the Average Monthly Sales of this product

Time

is the average lead time for this product

Obn Pos

is the quantity already ordered through vendor purchase orders

Order

is the quantity that the program determined should be ordered by taking Reorder Point - On Hand - Committed + On POs   or the Reorder Qty if one is specified