How Accelerating a Sage X3 ADC Solution Changed Everything – Increased on-time delivery by 46 percentage points (50 to 96%)

casestudyincrease

“We’re delighted with the process and outcomes, and the support provided by 4aBetterBusiness and Element ID, as impressive as those results are, we’re especially pleased with the way the process developed the engagement and buy-in of our employees.  This will enable ICM to sustain those gains and achieve ongoing improvements in performance and profits.”

– Levi Cottington, ICM CEO 


Background

ICM Products (ICM) is a specialty chemical company producing an industry-leading array of chemical compounds including silicone polymers, defoamers and specialty emulsions for a wide variety of applications.  The company has grown through acquisition from a single US location to an international company with operations in the US, England, Italy, and China.

ICM Products has experienced significant expansion through acquisitions.  The complexity surrounding integrating the new operations was made more difficult by a lack of data automation, automated workflows and product visibility.  On-time delivery had slipped to 50%.

To get operations firmly on track, ICM engaged 4aBetterBusiness, an implementation-based consultancy that deploys proven strategies to help companies improve productivity, cut costs and increase profits. 4aBetterBusiness identified multiple areas in which ICM could make improvements, and worked side-by-side with management and employees implementing those changes.  The changes improved on-time delivery to 86% within 5 months.

ICM was still manually entering data into its Sage X3 system, compromising efficiencies and introducing the opportunity for data entry errors.  Closing transactions could take from several days to a week.  Inventory counts were unreliable.  Without adequate real-time visibility into stock levels, higher levels of stock had to be maintained, and frequent schedule changes were required to accommodate materials availability.

To address these issues for the next stage of improvement, 4aBetterBusiness identified the use of bar codes / RFID to automate capture and processing of the data, and use of the Automated Data Collection (ADC) module of the Sage X3 module as effective solutions.   From discussions with a number of potential providers regarding bar code / RFID implementation, Element ID stood out with their focus on improving business results (not just implementing technology) and prior experience working with X3 partners.

 

Opportunity and Challenge

Toward the end of the year, ICM needed to carry out a full inventory of ICM’s facility, including weighing of each of the thousands of containers in the production and warehouse areas.  After a trial inventory proved out the approach to be used, the full inventory was scheduled for 3 weeks after the trial’s completion.

Recognizing a major opportunity for ICM, 4aBetterBusiness President Paul Vragel proposed that all of the product in the warehouse be barcoded when it was handled, warehouse locations be identified and laid out, and the company start using barcode / RFID scanning immediately at the conclusion on the inventory.   New CEO Levi Cottington and CFO Tom Gawlik agreed that this was the right opportunity to introduce barcoding technology – if all the work could be done in time.

EID_casestudy_mock-up

EID_casestudy_dl-button

Response and Execution

Vragel contacted Element ID CEO Jack Romaine and laid out the challenge.  Romaine responded immediately.  Romaine conducted an initial on-site survey at ICM and, together with Vragel’s knowledge of ICM’s operations and needs, developed an initial design for the barcode / RFID-capable system.

Mapping out the overall implementation process, it appeared feasible to put in place all the infrastructure components – printers, readers, labels, and location labeling in the warehouse.  This would allow collection of the right data for ICM’s operations.  However, it was clear that there was not sufficient time before the full inventory to configure and install the ADC module for Sage X3.  This left open a critical issue of how to get the data from collection to retention and into X3.

Trying to maintain a separate database and reconcile that to X3 would be a nightmare. Over a weekend, Vragel and Romaine developed an alternate method which allowed capture of the digital data, and direct “injection” of the data into the appropriate locations in X3.  Furthermore, this could be done using existing ICM resources.

The project was effectively divided into two phases:

 

Phase I:
to be completed before ICM’s scheduled full inventory (in 3 weeks), was to implement all the operational components needed for digital collection of the data on the shop floor

Phase 2:

to follow, would include the full integration of the data collection with X3 using the X3 Automatic Data Collection module.

Phase I –Establish Digital Data Capture System

Within 3 weeks:

Element ID identified, obtained, purchased and configured the needed equipment (handheld barcode/RFID scanners, barcode/RFID printers, barcode/RFID labels and separate equipment for the capture database) and came on-site for the final week of implementation, along with a senior engineer from an X3 implementation partner.

4aBetterBusiness led the efforts for ICM, determining the processes that needed to be in place to capture data on ICM’s operations and how those transactions would be defined in the system, labeling of warehouse locations and development and delivery of operator training.  Capture processes were developed, tested, and documented.  Operator training was developed and operators were trained in use of the system.

According to Jack Romaine from Element ID, “Technology is only a part of the total solution in these types of projects.  The human element is often your biggest risk.  Paul Vragel of 4aBetterBusiness was a critical part of the solution by assuring success through understanding the existing process, training the operators, and getting the “buy-in” at all tiers of the company to assure the system would be used”.

 

Phase I – Success

“This initial system gave us immediate improvement in the quality of data capture, while we worked out what was needed to implement the full ADC system”

 

– Chad Pickle, ICM , Director of Supply Chain

 

On conclusion of the full inventory, three weeks after the “flag drop” start, ICM had a fully labeled and lined-out warehouse, barcode / RFID labels on all the material, and was capturing data using handheld scanners and barcode / RFID labels on all the material.

Additional benefits achieved immediately in Phase I cited by Pickle:

  • Provided the opportunity to review transactions and apply corrections if/as needed before the transactions were entered into X3. This eliminated having to discover, analyze, and correct errors (initial operator errors, start-up issues, as-yet-unidentified process issues) after the errors were already in the database
  • Established a production environment in which employees became accustomed to use of the handheld scanners and transaction tracking
  • Enabled additional process changes needed to ensure a smooth implementation of ADC to be identified, implemented, and tested before the ADC rollout
  • Reduced errors by eliminating hand-written data recording and transcription
  • Minimized time for finding and handling materials
  • Reduced frequency of materials-related changes in production schedule

On-time delivery improved from 50% to 86%.

 

Phase 2 – Value-Added Implementation of ADC

Phase 2 of the project, full implementation of the ADC module, proceeded a few months after completion of Phase I.  With the success of the Phase I implementation, ICM again engaged 4aBetterBusiness to lead the effort.

Being forced to implement using a 2-phase approach, which initially seemed like a disadvantage, turned out to be a significant advantage.  It is critical when operators are directly scanning information into the X3 database that that information be correct, since finding and correcting errors is difficult, time-consuming and expensive.  “By reviewing the transactions from Phase I”, said Vragel, “We were able to identify and resolve issues that otherwise would have arisen only after the cutover to the new system.”

 

Preparation Yields Rollout Success:  22% reduction in inventory, 96%+ on-time delivery

The thorough preparation through process reviews and implementation changes supported by 4aBetterBusiness and the X3 partner paid big dividends to ICM for the rollout of the ADC module.

Before noon on the day the old system was switched off and the new system switched on, the first orders using the entire, end-to-end system were being successfully processed.

With the data captured now going directly into X3, the benefits ICM saw beyond those in Phase 1 included:

  • More robust inventory controls that prevented processing errors
  • 22% reduction in inventory
  • Improved cycle times for order processing
  • 96%+ on-time delivery
  • Personnel freed up from transcription of data into X3 to more productive tasks

 

header7

4aBetterBusiness, Inc.

Address: 1417 Main Street Evanston, IL 60202

Phone:(847) 606-2605

Paul Vragel, President

pvragel@4abetterbusiness.com

large_logo

Element, ID

Address: 520 Evans St #3, Bethlehem, PA 18015

Phone: (610) 419-8822

Jack Romaine, CEO

sales@element-id.com

 

EID_casestudy_mock-up

EID_casestudy_dl-button

Compensation costs are up but the visionary companies still increased profits – RFID can boost your profitability too.

graph, glowing, increasing

According the US Department of Labor, compensation costs in the US increased 2.2% in 2016. Did this reduce your corporate profits? A typical manufacturer that we work with is spending about six minutes per transaction recording production using pen and paper. Often, we find their production workforce allocating 10% of their time to data collection.

By switching to RFID, manufacturers experience several immediate benefits. Profitability increases because production output goes up when employees aren’t burdened by data collection, and instead focus on the jobs they were hired for. Imagine every production worker in your plant working 11% longer and not having to pay them a penny more. Profitability also increases because managers make better decisions using real time data. There is less waste and production bottlenecks are resolved more quickly when managers immediately spot changes in output and address them. The data set improves with machine captured data versus the chronic errors that result from transposed numbers, illegible handwriting, and missing slips of paper that are common in pen and paper tracking.

The best applications for RFID are automated tracking of trays, bins, totes, and other containers that are used over and over. The RFID data capture devices are mounted in key areas or on production equipment and provide fully automated, hands-free scanning of these containers. This can update a products location, update its stage in the production process, issue raw materials to a work order, or production track newly produced WIP or finished goods. Linking these records produces real time traceability records.

toll road with easy pass
Think of it like the toll roads.

Remember when you had to stop and get the ticket to get on and then stop again to pay on the way off? That is like pen and paper data collection. RFID is like the express lane where you never even need to slow down. By the way, those toll tags are actually a more expensive form of the RFID we deploy in manufacturing. It means higher profits for your company and it can help you offset rising compensation costs.

Is 2017 the year you will implement the project to increase your profits?

Your bonuses?

Create the opportunity to pay your employees more without hurting the bottom line?

Cheers to the Barcode!

canstockphoto12370940

Let’s take a step back from RFID and pay homage to that which came before – the barcode!  Barcodes gained in popularity over 40 years ago and have been the workhorse for product identification ever since.  Part of the problem with RFID expectations and adoption rate started with the technology being marketed as a replacement to barcodes rather than a supplement.  Couple that with RFID taking shape in its own silo outside of the traditional automated data collection (ADC) market and it is no surprise that we ended up with RFID vs barcode like Ali vs Fraser or Yankees vs Red Sox instead of thinking about barcode and RFID as two stars on the same team.

Barcodes are proven technology.  There is a great ecosystem in place to support the deployment of both the labels and the infrastructure.  A typical manufacturer or warehouse has plenty of choices and there are lots of good integrators that can successfully complete a project.  And let’s not forget that deploying barcodes generates a high return on investment because the technology is relatively inexpensive, but packs a lot of punch in its ability to improve inventory management and traceabililty.

Our philosophy is that every facility would benefit from a combination of barcode and RFID.  Most integrators sell either a screwdriver or a hammer.  As you would expect, they see every project as screws or nails.  To the customer, however, there are just business problems.  “We need data on this process” or “we need to find things faster in the warehouse”.  The best way to help the customer is to evaluate each problem on its own and determine the best tool for that job.  The best tool for “picking” is probably different than the best tool at the dock door.  Issuing raw materials to a work order likely needs a different solution than creating finished case records.

The barcode isn’t going away anytime soon and RFID is never going to completely replace it, in our view.  To us, barcode and RFID are different tools in the tool box that can make a business run better when applied effectively.  We need more integrators that can apply either technology or perhaps more integrators to partner and work together so that the best technology is selected for each individual manufacturer’s challenge.

End customers need to be sure their integrator partner has evaluated both barcode and RFID for suitability and made the best choice for each aspect of the business based on value to the customer – not just because “I sell barcode” or “I sell RFID”.  It would be rare for an optimized data collection system to be 100% barcode or 100% RFID.

So let’s toast to the barcode and apply it wisely.    Cheers!

Big Data, the Internet of Things (IOT), and Today’s Manufacturer

Big DataIt’s difficult to talk about any industry these days without hearing the phrase “Big Data”. In the era of the “Internet of Things” it seems every piece of consumer technology we encounter is communicating with the technology around it and everything we do online ends up in some marketing database. But how can a manufacturer leverage the Big Data innovations to increase profits and improve quality to drive higher sales?  Is “Internet of things” real technology and can it help?  Let’s get beyond the marketing flash and see how this can benefit manufacturing.

First, the good news.  Most manufacturers already own the costliest part of a Big Data system – the software to house and process the data.  This is generally your ERP system but could also be an MES or MRP system.   These software systems provide the tools to slice, dice, and analyze the data you collect.  Oops.  Now the bad news.  Most manufacturers are not feeding these systems with real time data.  Often that is because the cost of acquiring the data is high due to a reliance on pen, paper, and labor.  The high wage cost (production level pay for entry level data collection), loss in productivity (a production worker is spending 20-30% of her time collecting data instead of producing), and bad/missing data have been the limiting factors.  But there is a solution!  Often with a payback period of 6 months or less!

“Internet of Things” is a marketing buzzword that is thrown around far too often.  What it really refers to is the same type of automated data capture technology that has been around for 40 years.  We are going to focus on two technologies in the “Internet of Things” that can most help manufacturers feed “Big Data” and reap the rewards of data crunching in the form of increased profits and more sales.

Use RFID to track location, movement, usage, cycles, production, and tie it together for traceability

The first is radio frequency identification (RFID).  Automated RFID systems allow you to capture case, pallet, or item information by passing in the vicinity of an RFID read station.  Mounting these on your equipment allows you to do real time material issues to a work order with full lot traceability and real time production tracking of new WIP or finished goods you produce.  The cost of data acquisition is essentially zero and there is no human intervention.  That means no missing or bad data from forgotten scans or lost/illegible tracking tickets.  You can also automatically monitor throughput and process time at, and between, your workcells.  Additionally, you can improve preventive maintenance on your molds and fixtures by measuring cycles and linking molds to early detection of quality issues.

An RFID system integrator will work with your ERP/MES/MRP provider to ensure a secure, flexible data collection and management partnership. An RFID system that can directly feed data into your existing ERP system allows your company the opportunity to get the highest return on its investment.  RFID has the ability to provide your decision makers with the reliable information they need to make the tough calls to get your company operating at its highest potential.

Use IOT Appliances to monitor almost anything and automatically trigger corrective action

The second is IOT appliances.  Despite the fancy name, these are basically the same sensor-based data acquisition systems that have been around for decades.  What has changed is the ability of these devices to internally filter, process, and format the raw data and feed it directly into your MES or ERP system.   IOT appliances allow you to connect production equipment to your software and monitor and record temperature, humidity, down time, alerts, flow, etc.  As an example, let’s suppose you currently rely on a production worker to notice if the gauge on the oven is reading over temperature and hope they call someone from quality.  Instead, your IOT appliance could continuously monitor the temperature and automatically put all trays coming from the oven during an over-temp event onto quality hold in your ERP system.  Imagine having up/downtime data on a machine 24 hours a day and being able to view that at the same time you look at throughput data.  Perhaps, most importantly, the output of these devices can be used to stop something that is going wrong in production almost immediately to allow corrective action.  Virtually any measurement that can be captured electronically can now be part of the data suite you feed into your existing software systems.

Beyond the Buzzwords

Big Data is really about collecting as much information as possible about your production process and the resources you use.  The cost to store and process this information is significantly lower than even a decade ago.  From these data, you can develop your key performance indicators (KPIs) and success metrics.  You can spot trends (good or bad) early and act on them.  Since most customers already own the tools to house and process the data the form of ERP, MES, and MRP software, our focus has been on capturing and delivering the data to these systems in a cost effective manner.

The Internet of Things provides the data capture solution.  Automated RFID systems capture the location, movement, usage, and production of materials, WIP, and finished goods.  IOT appliances capture measurements and messages from your equipment.  Advances in technology have allowed these devices to talk directly to the big data software and have greatly reduced the cost of data capture.  By combining all this data together, manufacturers can now have the tools to improve profitability, increase capacity, and increase quality.

Accelerating an X3 ADC Expansion Project for Automated WIP Tracking or WMS

hairblowinginwindSuppose you’ve been tracking production and inventory using pen and paper and you recently upgraded to a Sage X3 ERP system.  Sound familiar?  Imagine you are the warehouse manager or operations manager and you really want to get going with WIP (work in process) tracking or implementing the WMS (warehouse management system) features in X3.  A lot of things are going on in the setup and configuration of X3 and your X3 VAR and IT Manager may tell you that you just have to wait until the system is fully up and running before trying to turn on X3 ADC (automatic data collection).  Still with me?  We don’t disagree with that logic, but the good news is that you don’t necessarily have to wait for full implementation of X3 to start boosting your profits.

Rolling out ADC requires many steps and configuring ADC and setting it up is certainly a time consuming and important part.  Don’t forget, you need a WiFi site survey, design, and install.  You also need to select hardware and software, choose RFID or barcode for each process, select label or RFID tag type for each item you want, and label all your address locations.  Most importantly, you need to get your employees used to scanning the barcodes.   What if there was a way to get all that started and begin benefitting from the data immediately?

I’m suggesting that there is significant benefit to proving out all the non-X3 hardware and software in the system before you are ready to turn on ADC.  I will also share that the biggest impediment to success of these projects is the human component.  You need a person to pick up the scan gun and pull the trigger to read the barcode or none of this works.  Starting that process early allows you to hit the ground running when you are ready to turn on X3 ADC because the scanning is familiar and a habit.  The added bonus is that you can begin using all the scanned data before ADC is setup and then port it over when the rest of the team is ready! 

These goals can be accomplished by feeding your scanned data into a database outside of X3.  This can be SQL, MySQL, or a proprietary third party product (ideally subscription based since you only need it for weeks or months).  Be sure your barcode/RFID scanners are equipped with software that allows you to connect to the database and then reconfigured to work with X3 to avoid paying extra (this type of scanner software is available).  This solution is intended to be a temporary way to capture and manage the data during setup and test of X3 and/or the ADC screens.  You capture and use the data in the temporary system and then export it as soon as you are ready to cut over to X3 ADC.  This accelerates your project, reduces the time to breakeven because you are increasing profits in weeks instead of months, and, perhaps most importantly, increases project success rates by training your weakest link (the humans!) to scan the correct items at the right times.  Low cost solutions to big money problems are essential to find.  If you’re warehouse has no automated data collection, this is something to immediately consider.

Found Money – How RFID Can Boost Your Profitability Over Handheld Barcode Scanning

Treasure Chest

Ask yourself:

  1. How much did I waste on extra physical inventory counts last year? Probably enough to buy another forklift or two or upgrade the dock doors or pay out a holiday bonus.
  2. How many transactions do I process? 1000 a day?  That’s about $50K a year to collect data.  How much more product could you make and sell if you put that $50K back into operations?
  3. How many workers have been diverted from production to “searching” for materials or finished goods that are lost and need to ship? Probably one or two.  How much double ordering or spoilage do you deal with?  Warehouse efficiency can probably increase profitability by over $100K.
  4. What is the cost of bad or missing data? You paid six figures for your ERP system.  How are you generating an ROI if you are not feeding it data?  Were you promised 2-3 points of improved profit margin?  That’s about $500K/yr for a typical manufacturer using ERP in the US and you are probably missing out on most of it because you have missing or bad data.

Together, that’s probably over $500K/year in additional profit for a typical manufacturer.

The necessity of a direct line-of-sight between the scanner and tag in barcode systems can often lead to frustration. Think about that can of soup at the supermarket checkout that the cashier waves over and over and you’ll better understand how your warehouse or production line workers feel searching for the barcode on a pallet or trying to get it to read through the shrink wrap once they’ve found it.

While that wasted time may see miniscule compared to total time of production and distribution, most managers can agree that when added up, those seconds could lead to a major time inefficiency.  At 30-45 seconds per transaction, you are probably spending a lot of money to read barcodes each quarter.  An even bigger risk is that the frustration may build to the point where workers just stop scanning and your six figure ERP system has no data going into it!

RFID eliminates the line-of-sight requirement and makes taking inventory seamless and hassle-free. RFID can also read multiple tags at a time whereas barcode scanners can only read a single tag at a time. This allows you to read tagged “each’s” inside a case without unpacking it.  Or read a pallet without getting off the forklift. You can cycle count an area without pulling out all the pallets.  And don’t forget the times the barcode is unreadable because it gets ripped, smudged, or fell off.   RFID tag durability and the ability to reuse RFID tags make it more reliable option for the manufacturing and warehouse environment.

So now, with RFID, transaction time becomes 10-15 seconds instead of 30-45.  Employees are more likely to scan consistently.  Better yet, moving from a hand scanner to an automated RFID read station or portal allows for the scanning to occur with no human intervention.  That means you are eliminating the human element in your data and you are freeing up worker time to produce instead of capture data.

Addressing our profitability points:

  1. Using RFID will make it quicker and easier to scan items in the warehouse. This means employees are more likely to scan so you have more complete and better data.  Adding an automated RFID portal allows you to audit the “put-aways” and provides the means to enforce scanning and correct errors as they happen.  RFID therefore reduces the number of physical counts required and reduces the time required to complete them since line of sight is no longer required and not every item needs to be pulled from the racks during the count.
  2. Eliminating line of sight requirements by using RFID speeds scanning time from 30-45 to 10-15 seconds per transaction. Easier scanning increases the likelihood that every item will be scanned.  Transactions cost less and employees are freed up to produce more.
  3. As in #1, better scanning and the ability to monitor and enforce it using automated RFID portals means your inventory data will be correct and you will know what you have and where it is. No more “searchers” and no more double ordering or spoilage because you can’t find it.
  4. RFID clearly helps in the warehouse as we’ve described above.  But those same benefits apply in production by using RFID portals and RFID read stations to automatically issue materials and production track with no human intervention.  For ERP systems to deliver on their promises, they need accurate data fed to them and automated RFID scanning allows this to occur.  Not only do you unlock the benefits of your ERP system, your ongoing cost of data capture in production becomes nearly zero since the scanning is automatic.  In addition to the profitability boost, you are also improving your traceability and bringing down cost of compliance!

Want to be the hero at work? Introduce your boss to this productivity booster for manufacturing!

Hero at Work

According to the US Government Bureau of Labor Statistics, labor productivity rose in 77 percent of the 57 detailed manufacturing industries during 20141.  So the mandate from the boss is to increase output.

“Oh, and by the way, you can’t hire anyone new and overtime is not an option” your boss adds while turning to walk away.

“What do you want me to do?”, you respond.

“You’ll just have to get more efficient like all those other companies”, your boss responds.

So now what?