Excess Inventory Report
The Excess Inventory Report provides information about the quantity of item(s) sold over a specified time period.
In addition, this report is designed to help you determine how well future sales needs are covered based on the volume of sales and current stock levels. For each inventory item listed, the report includes the current number on hand, the item's location, the item's total cost, average monthly use, and number of months in stock. Additionally, the value of excess inventory is calculated as the dollar value of inventory that exceeds the average usage for the specified time period.
Note: Regarding Excess Inventory Report
calculations — The average monthly usage amount is determined by the shipped quantity for
the date range indicated on the report starting screen. The following equation is used to
determine the average monthly usage amount: Current on Hand / Months in Stock.
