Inventory Management Practice. MANAGING THE COMPUTER-CONTROLLED INVENTORY SYSTEM. How to Achieve Inventory Accuracy.

June 26, 2009 by kutenk · Leave a Comment
Filed under: Inventory Management 

Inventory Accuracy

What are the signs that inventory inaccuracy is an issue in a plant? Inventory inaccuracy may cause excessive downtime in a plant due to lack of materials.
Many companies schedule monthly physical inventories because they do not trust the perpetual numbers. These physical inventories are a waste of company time and money and prove that no one understands how to manage materials.
Numerous factors can directly influence the inventory accuracy. The most important practice that a materials team can adopt is developing verification systems to ensure that all data in and out of the materials requirement planning (MRP) system is correct. Although double-checking takes time, it is worth the effort to keep the inventory as accurate as possible.
Inventory inaccuracy may result from software issues, data input/output errors, transaction errors, cycle-count errors, and unreported scrap.




The software maker or the company’s information systems department should resolve software issues that create problems with inventory management. Most software issues occur with the transfer of data from one software package to another or in daily updates where numerous programs interface with each other and one has crashed. An overloaded hardware system is usually the root cause of system crashes.
If a plant and/or company is plagued with constant shortages due to incorrect perpetual inventories on the computer system, there needs to be an extensive review of how the inventory is managed. The number-one cause of firefighting is the inability to control the computer system inventory (perpetual).
Once people lose faith in the accuracy of the data in the computer system, they usually establish methods to circumvent the system, such as using expediters and stock chasers.
Many planners revert to managing the inventory with spreadsheets. The danger with using spreadsheets is the fact that they could contain errors that allow the generation of inaccurate releases.





MANAGING THE COMPUTER-CONTROLLED INVENTORY SYSTEM
Efforts to correct the inventory on the system may be in vain due to a host of reasons, both within and beyond the control of the materials group. Even when a new perpetual inventory is posted to the system from a physical inventory, if the reasons for the inaccuracies are not corrected, the information quickly becomes inaccurate.
The problem of maintaining an accurate perpetual inventory can be compounded by efforts to correct the system with arbitrary inventory adjustments.
Compounding errors result from failure to identify the root causes for the inventory inaccuracy and take corrective action. However, due to time pressure and inability to understand the root causes, quick adjustments may be the materials group’s only way to adjust the inventory.
The lack of time to research the root causes stems from having an overwhelming number of cycle-count adjustments and not enough people to manage the situation.
Errors can be compounded by inaccurately correcting a problem that is corrected later by the proper transaction, such as by finally entering a missing receipt into the system. Entering the missing receipt actually doubles the amount of the inventory when a cycle count was used earlier to correct the system.
Errors are compounded when one cycle count reduces the inventory and the next cycle count increases it. Such changes render the inventory extremely inaccurate without a double-check verification.
Inventory inaccuracy is a symptom of system failures, lack of discipline, and lack of knowledge to implement proper system controls. If an overwhelming number of cycle-count adjustments are made monthly, the materials group generally is in an endless firefighting mode. A concerted effort is required to get back to the basics.
Inventory accuracy depends on the plant’s ability to control receiving accuracy, proper storage, scrap reporting, rework, vendor count, bills of materials, cycle counting, shipping accuracy, finished product reporting, and data input/output control.
With so many direct inputs into the system that can affect inventory accuracy, it is difficult to ensure that all transactions are correct. Any system that relies on human input is bound to contain errors. Those who understand how to minimize the errors will have the advantage.
If inventory control was on par with accounting practices, perhaps the view of controlling materials in the plant would change. Accountants are simply not allowed to adjust the ledger in order to balance the month. Accountants also have double-check systems that allow them to reconcile the ledger. Why should inventory control be any different from controlling the company’s cash? After all, inventory is money.
The level of inventory accuracy usually depends on the plant’s ability to formulate corrective action plans from a root cause analysis of a problem. If no corrective action plan is formulated to resolve accuracy issues, the inventory inaccuracy problem continues to compound to a point where every physical inventory results in an unacceptable loss.
Even when the physical inventory does balance within reason in dollars, a part number review may reveal a different result. This may happen when the counts for the highest dollar items in a plant are more accurate than for the rest of the components. For example, if there were 1,000 parts of X, at a cost of $800 each, the inventory would be $800,000. If the balance of 2,500 part numbers totaled $100,000, it would be possible to balance within reason on the ledger during a physical inventory. The materials group’s understanding of the dollar structure of the components used would most likely ensure that part X is always correct.

  • Share/Bookmark

Tags: , ,