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
  • Best ERP Features and Benefits for Your Business

    Are you considering investing in ERP software for the first time? Or maybe you already have an ERP solution but you’re worried it’s becoming dated. If either of the above apply to you, read our latest guide on the top ERP features and benefits based on the size of your business. You may be surprised at how versatile and cost-effective it is becoming - regardless of if you own a small business or run a large enterprise. more

  • 8 Ways the Cloud is Changing ERP for the Better

    What if there was a tool available that allowed for you to save up to a quarter of your operational costs? Studies have shown that Enterprise Resource Planning (ERP) solutions enable businesses to access accurate, real-time information about daily operations which allow for the reduction of operational costs of up to 23% and administrative costs of up to 22%. more

  • 7 key questions to ask any ERP provider

    Having a fast-growing business is good. Having to overhaul your technology every time you need to scale is not. Upgrading to a more complete Enterprise Resource Planning (ERP) solution can help, but how do you ensure the solution you choose is exactly what you need? To help you with your search, we’ve pulled together 7 key questions every fast-growing business should ask before choosing a cloud-based ERP solution, including: more

  • How Finance Leadership Pays Off

    Oxford Economics recently surveyed 1,500 finance executives and it’s clear that small and midsize companies are growing significantly faster than larger companies. But, there are also big opportunities for finance to increase efficiency, boost financial performance, and work more strategically. Why is that? more

  • Professional Services Audience – Improve Profitability Infographic

    As a Professional Services Organization (PSO), you know the importance of customer satisfaction. In fact, 47% of PSO leaders say managing changing customer expectations is their top challenge. That’s why many firms are engaging smarter project management technology, even before deals are signed, to ensure project profitability. How are these leaders utilizing technology? Find out now. more