ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon WireHarness Manufacturing
DrillDown Icon Alternate Parts
DrillDown Icon Outsource Management
DrillDown Icon Documentation Control
DrillDown Icon Supply Chain Management
DrillDown Icon Happy Holidays
DrillDown Icon Customer Credits
DrillDown Icon Publication Changes
DrillDown Icon System Triggers
DrillDown Icon Multi-shift communications
DrillDown Icon Find by Ref Desg
DrillDown Icon BoM Importing
DrillDown Icon Kitting By BoM
DrillDown Icon Minimum Buys and Residual Inventory
DrillDown Icon Customer Part Number Cross Referencing
DrillDown Icon Performance Tracking
DrillDown Icon Work Order Numbering
DrillDown Icon Inventory by Project
DrillDown Icon Counterfeit Components
DrillDown Icon WC Priorities and Scheduling
DrillDown Icon ManEx Minute - Attrition & Scrap
DrillDown Icon ManEx Minute - Kitting
DrillDown Icon ManEx Minute - Assembly Revisions
DrillDown Icon ManEx Minute - Cycle Counting
DrillDown Icon ManEx Minute - Order Status Updates
DrillDown Icon ManEx Minute - Excess Inventory
DrillDown Icon Business Case Solutions - 11
DrillDown Icon ManEx Solution - 11
DrillDown Icon ManEx Minute - MRP Filtering
DrillDown Icon ManEx Minute - Part Shortage Tracking
DrillDown Icon ManEx Minute - Reader Survey
DrillDown Icon ManEx Minute - Supplier Communication
DrillDown Icon ManEx Minute - Production Flexibility
DrillDown Icon ManEx Minute - AVL Management
DrillDown Icon ManEx Minute - Production Offsets
DrillDown Icon ManEx Minute - Obsolescence of MPN
DrillDown Icon ManEx Minute - Customer Owned Inventory
DrillDown Icon ManEx Minute - MRP Sharing
DrillDown Icon ManEx Minute - Announcement
DrillDown Icon Survey Results
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
ManEx Solution - 11 - Excess Inventory


ManEx Case Solution

ManEx provides several tools to allow users to purge, prevent, and prepare for excess inventory. 

REPORTS:
Standard reports will allow users to identify parts without an assigned BoM, parts that have had no transactions as of a given date, and parts allocated to closed jobs.  If parts are allocated to a project in the purchasing process, then users can see all parts on hand at any given time purchased for that project.  Additionally, users can create unlimited custom reports to better control excess inventory.
 
MODULES:
Project - This module allows users to allocate parts to a project, which not only controls how the parts are used, but also provides accurate and complete on-hand values for those parts and the project.
In-Plant Stores - This module is commonly used to manage excess inventory purchased by the customer that will be consumed at a later date.  This allows visibility and accountability for the parts and keeps the inventory value off the books until they are used in production.
Quote - This module allows users to identify excess inventory in the quoting process.  With this information, users can establish contracts with the customer to account for the excess value and reduce its impact on cash flow.  It also provides visibility of existing part numbers and inventory so users can consume existing inventory before purchasing more.
Inventory Control - This module allows users to consolidate demand by managing one internal part number to multiple supplier, customer, and manufacturer part numbers.  It facilitates part cross referencing to quickly identify other internal part numbers that may be used as an alternate.  It allows users to calculate and track the EAU for a given part.
Import - This module identifies existing part numbers allowing users to decide if they want to consolidate demand, or keep them separate.
Forecast - This module allows users to systematically monitor and enforce demand fluctuations according to contract limits.  When the user uploads the latest forecast, it will adjust existing demands by acceptable limits allowing for a more steady flow of material.  Any changes outside of the agreed upon limits are identified and will require user intervention ensuring these changes do not go unnoticed.
ECO - This module allows users to document and track changes to an assembly.  This way they can see when AVLs were added or removed and more fully investigate the impact of these changes on excess inventory.  Users can also prepare a quote for the cost of the change within the module, keeping all information together, and helping to control excess inventory levels.
 
 
CONCLUSION
 
NE Company was able to quickly reduce on-hand excess inventory by returning a portion to the suppliers, using approved parts on other orders, selling parts through consignment, and selling a portion to the customer.   They estimate that 27% of their on-hand inventory is still excess, but their steps to update system settings, consolidate demand, and monitor projected excess inventory levels should allow them to bring that down around 19% over the next six months.  Management decided against writing off excess inventory, at this time, because a significant portion of the excess inventory is on the AVL for a job currently in quoting and for which they hope to get an order later this year.

They have also taken steps to manage excess inventory as it arises.  They established contracts for excess inventory with their customers.  They have the Project Module and In-Plant Stores Module operational allowing them to fully track inventory levels and values, and invoice as needed.  NE Company also created a customer statement* that provides an overview for the total customer liability.  By providing this statement to the customer each month, both parties understand total liability and responsibility at the component, assembly, invoice, and order levels.
 
*an example of this customer statement can be provided upon request.
 
Article ID: 3188