1. ManEx Minute - 342008 - Customer Owned Inventory
 
Keep me out of SPAM!  Please add newsletter@manex.com to safe senders list.
 
 

In This Issue

Readers Poll

Poll Results

To view results from previous polls, please complete the poll above. 

 
 

INSPIRATIONS

"Patience and perseverance have a magical affect before which difficulties disappear and obstacles vanish."

-John Quincy Adams
 
 

  

Subscribe to ManEx Minute

Issue 342008
Greetings,
 
For this issue, we address managing customer owned inventory, specifically addressing inventory that will eventually transition to turnkey. However, the results and actions may be similar for obsolete inventory stored at your location, excess inventory owned by the customer, and supplier owned inventory. Material is a significant portion of you COGS and improperly handling or managing this inventory can quickly consume your profits.
 
As always, We look forward to your participation and feedback as you gain new insights and become a more effective provider of Electronic Manufacturing Services.

Sincerely,
 
David Sharp
ManEx, Inc. 

Business Case - Inventory Control 
Customer Owned Inventory 
   
North Eastern Company* (N.E. Company) has made significant progress in controlling and improving their processes.  They are ready to win new business and have started to reap the benefits of the increased capacity created by their efficiency improvements. 
 
As they gain new customers, they notice a common transitional period where the customer initially supplies a significant portion of the required material until the excess inventory is consumed at which time NE Company will assume responsibility to procure the components.
 
This non-standard inventory presents a challenge both fiscally and logistically.  How will they reflect the cost of the parts provided by the customer?  Will they give a credit, reduce the price of the assembly, or purchase the parts from the customer?  How should they track the parts to ensure they get used as quickly as possible?  How will they know when the inventory is depleted in order to insure new parts will be delivered on-time?  

Business Case Solutions
  1. Separate Excel Spreadsheets - This is a quick solution that can be implemented at almost any time with any customer.  It typically doesn't require a lot of setup, but the ongoing maintenance can be time consuming and have multiple opportunities for human error.  For one-time, small part number lists, this may be a good and cost effective way of dealing with the issue.  However, you will need to find a way to ensure the parts are used when available, paid for or credited when used, tracked in the system if needed, and that replacements parts are ordered in time when inventory is depleted.

  2. Create Separate Warehouses - If Accounting is not tied to production and material management, or if you have the ability to exclude inventory in a particular warehouse from showing on any financial statements, then creating separate warehouses for each customer, may help in tracking this inventory. This gives visibility of the inventory within the system, but you must be careful that creating a non-standard warehouse does not have negative impacts in other areas and processes within the system.

  3. Loaded as Consigned Inventory - Most ERP systems will allow management of Consigned Inventory.  If the customer furnished inventory is loaded under consignment then it will be visible for consumption.  Although this requires more setup than Excel spreadsheets, it should be fairly quick and allow system tracking of usage and on hand quantities.  Consigned inventory is typically handled differently than turnkey inventory so that means these parts will have to be setup for consignment initially and converted to turnkey at some point in the future.  This method also requires additional methods for tracking customer credits and purchase action items when the inventory is depleted.

  4. Treat the Customer as a Supplier - Sometimes it is easier to simply purchase the parts from the customer as needed.  This method solves the issues from the first three methods by allowing you to setup the parts correctly from the start, provide proper credits as needed, easily transition from customer furnished to full turnkey, and track the demand and usage in the system.  Depending on the system capabilities you may have to force the system to purchase from the customer until the inventory is gone and then allow the system to choose the best supplier thereafter.  Without system provisions to handle the inventory, this method will require you to either track the available quantities outside the system, or sit on excess inventory until it is consumed by the customer.

* Company name has been changed.

ManEx Case Solution


Make
YOUR Mark

Here is a list of upcoming topics.  Please email your thoughts, comments, and suggestions to mym@manex.com

  1. Lot Tracing
  2. Obsolescence of Manufacturer Part Numbers
  3. Production Offsets
  4. Comprehensive AVL Management
  5. PO Notes

If you have any topics you would like to see addresses in future newsletters, please send them to topics@manex.com.

©2008 All Rights Reserved.
ManEx Minute is a weekly email distributed by ManEx, Inc.

ManEx_Logo

Developing with YOU in mind! 

1.1. ManEx Solution - 342008 - Customer Owned Inventory


ManEx Case Solution
 
For companies with similar circumstances to NE Company, using built-in capabilities to reduce time and human error is the best option.
 
To use the module and get the benefits, NE Company followed the following steps with each batch of inventory using the In-Plant Store (IPS) module:
  1. upload the new inventory quantities to the previously established parts list
  2. update contract pricing as needed
  3. consume the parts in production
  4. purchase the parts, from the customer, according to contract timing and pricing
Using the IPS, NE Company was able to easily manage a large number of parts.  They were able to effectively overcome common issues with multiple inventory types and owners, while providing value-added solutions to their customers.  With this module they have:
  1. total visibility of the AVL and quantities on hand,
  2. MRP consume all inventory before purchasing more,
  3. control and visibility of contract pricing,
  4. purchasing easily "order" the parts as they are consumed,
  5. receiving automated since kitting from IPS removes the need for receiving,
  6. no inventory value on the books until the parts are pulled for production,
  7. the ability to quickly upload new inventory quantities if needed. 
Compared to their old process of separate excel spreadsheets, the new module is much faster and more accurate.