Making your ERP System live with your Kanban System
This Kanban Control Board has lead to reduced inventory, transactional workload and shortages at this small manufacturer. As materials are consumed, kanban cards are returned to this central board for re-order by purchasing.

Making your ERP System live with your Kanban System

When it comes to ensuring you have the right materials in the right place at the right time, kanban systems are a simple and highly effective tool. Kanban systems work for three primary reasons :

  1. They are simple to operate (once set up),
  2. Replenishment is triggered by actual usage of parts rather than theoretical and error-prone forecasts
  3. Inventory is controlled physically rather than through an ERP system. This eliminates the problem of inaccurate inventory records in the ERP system. It prevents the wrong materials being purchased at the wrong time.

 

The outcome of a well designed and maintained kanban system is that your problems with part shortages are likely to disappear. The effort required to manage materials can be dramatically reduced.

Inventory, ERPs and Kanban

In most manufacturing businesses, inventory is the largest component of working capital and a major business asset.

Maintaining accurate inventory records is therefore critical to maintaining an accurate balance sheet. It also helps to avoid large “profit busting” stock write-offs as inventory is usually recorded in an ERP system.

Kanban’s great benefit is that it uses a visual trigger based on physical stock levels to trigger replenishment. Therefore how do you connect these physical transactions with what is being recorded on your balance sheet via your ERP system and avoid large inventory errors and write-offs?

The Keep it Simple – the “Parallel Universe Approach”

I think “keep it simple” has been a message in most of the blogs I have ever written and this is no exception. If you ask your ERP vendor how to make kanban work, he or she will give you a software solution (and probably one that involves a forecast). This immediately negates the three major benefits of Kanban systems that I have outlined above.

You should reject this option. The simplest solution is what you could call a “parallel universe” approach. This means that the kanban system and the ERP operate in “parallel universes” with the minimum number of checks and reconciliations to keep inventory records reasonably in line.

Managing Suppliers in a Parallel Universe

For each supplier, a monthly “blanket order” can be raised. This will include an approximate quantity that you expect to consume for the month. The supplier should know that this is not a forecast and they are not to produce and supply this quantity.

The actual quantity supplied is determined by the supply of kanbans to the supplier. Each day (in the case of daily deliveries) the supplier will supply exactly the amount determined by the kanbans the supplier has received.

The supplier provides a “proof of delivery” (e.g. a delivery docket) with each delivery. Your stores’ team then reconciles this document against the goods received and the kanbans. At the end of the month, the supplier invoices for the quantity actually supplied and this is then reconciled against the goods received. The purchase order is then adjusted to reflect the actual quantity received and closed out.

To record consumption in this simple system, a backflush is used. This means that as finished goods are completed and transferred to inventory, the ERP system automatically deducts a quantity of raw materials from inventory corresponding from the quantity of finished goods produced, based on the bill of materials.

Dealing with Work in Progress in a Parallel Universe

My (controversial) suggestion for work in progress is not to record this in the ERP system at all.

Aim to have “single level” bills of materials that just record the raw materials that are required in the finished goods. Work in progress can be accounted for through a periodic stock count. I can hear the screams of an army of terrified accountants at the idea of not recording WIP, but on more careful consideration there is little to worry about.

Firstly, we are not removing all control from WIP. On the contrary, we are putting in place a lean system (a kanban system) that very tightly controls the location, the quantity and the production of WIP.

The level of WIP will not exceed the number of kanbans in circulation. Secondly, very few companies I have dealt with manage to maintain accurate WIP inventory records anyway.

This is because production recording in the ERP almost always lags the actual progress of production (some times by a whole day). By the time WIP Inventory is created in the ERP system, it has already been physically consumed in production. This means that the WIP records are never very accurate anyway.

The “parallel universe” approach does require regular cyclic stock counts (perhaps monthly or bimonthly) to ensure that the kanban system and the system inventory do not get too far out of alignment.

Tighter Control – for Nervous Accountants

Most large organisations are going to struggle to accept my “parallel universe” method. Also if internal process lead times are long (which you should be trying to reduce) and WIP value is high, you may not be able to live with single-level bills of materials. In this case, you will need to integrate your kanban system more tightly into your ERP. Fortunately, this is not particularly difficult.

When compared to the simple system described above, integration can add some administration time. It can also add some lead time into the processing of purchase orders and production orders. It may also require some software changes, which are usually costly and can take a long time to implement.

Purchase Orders and Kanban

In this system, material kanbans are routed via the purchasing department. For each kanban, a purchase order is raised on the supplier or else kanbans for a particular supplier are accumulated during the day and purchase order raised for all the materials required from that supplier.

This batching increases the lead time.  However, raising a PO for every kanban may lead to a huge number of orders. This may add to the cost of administration.

The important rule is that nothing can be ordered unless a kanban is triggered.

This system can be further improved if kanban cards are barcoded. In this case, scanning the barcode on the card triggers a PO (or preferably a purchase requisition against a PO). This purchase requisition or order can then be emailed directly to the supplier.

In either case, when the goods are received they are also received on the system and the PO (or requisition) closed. The supplier is required to supply the exact kanban quantity. As a result, there should always be a match between the quantity ordered and delivered.

Kanban and Work in Progress

For work in progress, kanban cards can be routed via the production office and each production Kanban can be converted into a production order in the ERP system.

Often several kanbans will be accumulated so a batch of the WIP component can be produced. Typically a production order is attached to the kanban card(s) and sent to the upstream process for the production of WIP item. When the WIP batch is completed and returned to the line then the production order is separated from the card and returned to the production office to be closed.

This process can also be streamlined by the barcoding of the kanbans and production orders. When the kanban is triggered, scanning of the card creates a production order.  The scanning of materials or the production order back in to the location closes the production order.

Kanban and Finished Goods

In terms of finished goods, they are receipted into inventory when they are completed.  The top-level parts (the components and sub-assemblies that go into the final assembly) are backflushed, since the kanban system is already managing the consumption of upstream parts.

Regular cyclic counts to ensure that stock accuracy is maintained are recommended.

Make sure that it is not possible to “cheat” the system by scanning a single kanban card multiple times. Allowing this practice will lead to a complete loss of control of your inventory.

What About the MRP and the Forecast?

Neither of these systems relies on a forecast or the use of the MRP functionality in your system. It is also important that you don’t overlay MRP, production planning or scheduling tools over the top of the kanban replenishment systems. This is likely to lead to conflicts, confusion and poor system performance. Your kanban system should ensure that you always have the parts you need when you need them. There should be no need to reference the forecast if it is designed correctly.

Your kanban system is not “set and forget.”

An understanding of monthly forecast demand ensures that you adjust the kanban system for changes in demand (e.g seasonal changes.).

If demand is increasing you might increase the number of kanban cards in circulation. When demand is falling, cards can be removed from the systems. Many companies use “temporary cards”, usually printed in a different colour, to build inventory above the normal level (e.g. for a promotion). These cards are then removed from the system once this additional inventory is consumed and the cards returned to purchasing.

Summary

There are different approaches that can be applied to maintain accurate inventory levels in your ERP system while operating a kanban system for replenishment. A key point to remember is that no inventory management system is “set and forget”. All systems require discipline, clear process rules and accountabilities and regular cyclic counts.

Timothy McLean

Author: Timothy McLean

Timothy McLean is the Managing Director of TXM Lean Solutions and is an author of Lean books.