Formula Manufacturers: Inventory Control Issues A Recipe For Disaster

Updated: September 01, 2010

During my review of business processes for prospects many times the Material Planner/Purchasing Manager is doing a visual review of the raw materials in the warehouse to verify inventory quantities to either complete purchase orders or create the production schedule. They don't trust their ‘system' numbers. Raw material inventory integrity is often one of the biggest problems that I encounter with prospects.

There could be many reasons why inventory control is such a pervasive problem:

  1. The use of separate accounting/financial systems for the inventory and manufacturing systems. Raw materials are ordered on one system and manually updated in another system.
  2. The purchase receipts are not completed in a timely and correct manner. Raw material is received at the wrong cost or wrong quantity. Human error. By the time the vendor invoice arrives the raw material has been consumed.
  3. Raw material quantities are purchased on one unit of measure but consumed in another unit of measure with incorrect conversion methods.
  4. Quality control is not tracked therefore inferior materials are hitting production causing production to use more than the formula or batch ticket calls for. Production is not recording actual.
  5. Not inputting quantities used for production or staging in a timely manner to relieve raw material inventory. Not having a work in process (wip) of the manufacturing process takes several steps and time.
  6. Cycle counting is not in place. Physical inventories occur once a year. Once a year is pretty extreme! Some companies complete this task once a month due to poor inventory controls.

The majority of the companies I encounter with these problems are using two or more systems to manage their business. Sometimes one or more of the business tools is a spreadsheet. I have nothing against spreadsheets as long as they actually tie back to a database that is driven by real transactions. One system for accounting and one system for manufacturing makes no business sense to me. This use of disparate systems can cause many problems; one being inventory control. If you are selling out of one system and manufacturing in another how do you know what your demand is for production? Is someone taking the sales orders and then filling out a production schedule? Then someone is updating one system with the finished goods to ship and invoice… I have to enter vendor invoices into the accounting system to cut checks, but I am purchasing in another system… Confusing? This scenario demands a lot of manpower just to function on a day to day basis.

Featured Research
  • How to Buy an ERP Solution

    Congratulations on making the decision to beginning the process to research and ultimately purchase an ERP solution for your business. Studies have shown that through accurate information about daily operations, companies can make decisions that reduce operational costs by as much as 23% AND administrative costs by 22%. more

  • The Future of ERP

    Today's business decisions are data-driven and the difference between success and failure can be boiled down to utilizing the correct data. Now more than ever, companies have access to not only robust data but consumable data as well, through Enterprise Resource Planning (ERP) software. more

  • Top ERP Trends of 2017

    No matter the size, success or industry in which you do business, data is vital. Because of this, data-driven technologies such as Enterprise Resource Planning (ERP) systems are becoming more important for the streamlining of quantitative data and gaining/analyzing key insights. Even better, as of 2017, ERP tools aren’t only for enterprise companies in the manufacturing and distribution sectors—they’re for everyone. But that’s not the only keynote change that’s taken place this year … Download our latest guide to see what else is happening with ERP! more

  • Making a Business Case for ERP

    Are you in the market for an ERP solution but hesitant to purchase due to the potential financial risks associated with implementing such a tool? While costs may seem prohibitive, and make it difficult to get stakeholders on board, an ERP system can add SIGNIFICANT value to your organization, regardless of what industry you are in. more

  • CIO eGuide

    Data is becoming increasingly important in business. As a result, more and more organizations are becoming attractive targets for hackers. Data breaches caused by stolen credentials are on the rise. You need smarter tools to protect your organization against the monetary and reputational damage caused by a data breach. This guide will explain how Okta Adaptive Multifactor Authentication (MFA) provides the security that IT needs, while also providing the simplicity end users want. more