Monday, September 22, 2008

Time to reflect - Lot Expiration


food manufacturing erp
Yesterday I celebrated by birthday. (insert noise makers here)
I had a GREAT day doing all the things I like to do best. That is what a birthday is about anyway – isn't it?
This blog the topic kept running through my head- "Lot Expiration" and "Shelf Life". I know it is a morbid thought but I just had to get it out of my brain and share it with my formula manufacturing friends.
Formula manufacturers – particularly in the food industries – are keenly aware of the issues associated with lot expiration and the financial impacts it can cause when a lot reaches the end of its prescribed useful life. What otherwise was once a perfectly suitable product has become as popular as the last kid picked on the recess kickball game. Not a fun site – trust me.
So how does a formula manufacturer address the ticking clock that is always running? Here are some ways.
  • Build a time machine go back to a time to address the issue. Not feasible but could be very effective.
  • Reduce the time to manufacture and progress toward a make-to-order model. This is very effective for the small batch manufactures with excess capacity in the manufacturing area. By holding inventory in raw materials you reduce the likelihood of finished good lot expiration – now you have to manage the raw material expiration but managing a fewer number of common raw materials is often easier than many finished goods.
  • Monitor lot production/expiration dates and notify appropriate users of lots reaching 50% of their useful life. This is pretty easy with today's technology. Imagine receiving an email from your system identifying the expiring lots with ample warning to take corrective action. As long as your ERP system data is hosted in an ODBC compliant database (such as MS SQL) then the task is pretty simple.
I feel pretty fortunate because tools are available in today's technology to deal with lot expiration. Vicinity by Vicinity Manufacturing is the primary application that I support on a daily basis. It helps my clients to reduce the time to production AND to notify user of aging finished goods lots. So 2 out of 3 is not bad. A little work with your IT group can make this issue a thing of the past leaving time to address bigger issues.
As a footnote: We are still working on the time machine concept – maybe by my next birthday we will have the perfected.
Until next time – take care and I look forward to talking with you soon

Wednesday, September 17, 2008

Scheduling by Formula – Why Bother?


production scheduling
I was at a client the other day and heard an interesting discussion.
The production scheduler was discussing an issue with the production manager about how the scheduler was scheduling production. The production manager was making the case that the scheduler was killing the production efficiency by changing products as often as he was. Production would like to run long runs of the same formula to avoid costly changeovers. Instead he was contending that the scheduler was requesting partial batches and forcing more clean ups than needed.
The scheduler was arguing that he was changing products to keep inventories low. His position was that low inventories was in the best interest of the company and the only way to accomplish that was to run short runs and for only the quantity needed.
So who was right?
My two cents is that a company needs to balance the needs of the customer (on time product often achieved by holding FG inventory) and reduction of working capital (keeping inventories as low as possible). But how can you do that in a formula based manufacturing facility?
The easiest way to achieve this balance is to look for opportunities to produce finished goods that share the same formula. In some facilities producing bulk formula is a possibility and then fill to order. From this bulk multiple finished goods can be produced off of the same blending/mixing batch of a formula. The result is to reduce the number of mixes of the formula which reduces the number of times a change over occurs in blending.
In other facilities multiple finished goods can be filled directly from the mixing tank without much bottling like changes.
It is important for a formula manufacturer's scheduling tool to be able to combine finished good SKU's by formula and then by filling line. This allows a scheduler to better see the opportunities to run like products at the same time. Thank goodness for me the application they are implementing (Vicinity) has this capability out of the box. This is not characteristic of products designed for assembly or discrete manufacturing.
So how did this end?
The scheduler looked out into the future at sales orders and forecasts and allowed the production manager to make some product that would be needed in upcoming weeks. At the same time the production manager grouped the formulas in a specific sequence to reduce his change over time.
Both came to me and asked that we move up the implementation of Vicinity scheduling. Not a bad day for me that is certain.
Related Posts Plugin for WordPress, Blogger...