Show/Hide Toolbars

SpendMap User Guide (v14.5)

Navigation: Inventory Control > Reports

Excess Inventory Report

Scroll Prev Top Next More

INVENTORY CONTROL > Reports > Excess inventory

 

This report lists items that are overstocked.

An item is considered to be overstocked if the in-stock balance (and optionally the on-order balance) of the item exceeds the Economic Order Quantity (EOQ) by a factor that you specify. The EOQ is defined for each item in the Item Master File.

 

Noteworthy Questions & Options

Number of times the EOQ?  This refers to how many times the EOQ the in-stock balance has to be for the item to show on the report. A higher number will result in fewer items being listed.

Consider on-order balances?  Since items that you’ve already placed orders for will eventually be received, you may want to consider these open orders in determining whether an item is overstocked. If you select [YES], the open (un-received) quantities on Purchase Orders and Releases will be added to the in-stock quantity before being compared to the item’s EOQ.