space space space
SAP | AMERICAS
space
December 2006  |  Subscribe   |  Archives   |  Contact SAP
space space
      SAP BUSINESS INSIGHTS    
     
space space space
space Inventory Accuracy: Superhuman Strength Will Not Fix It
By Dan Sechrist, Red Moon Solutions LLC

There is nothing like waking up to the reality that you cannot use your superhuman powers to cure the inventory problems that plague your company — at least not without some organizational help. By the way, is that a negative inventory count in your accounting system? What exactly does that mean?

The difficulty of tracking inventory stems from the complexity that exists in manufacturing environments. For a business to buy one item, change its form and ship it to a customer, the process is simple. But it is nearly impossible to buy 10 items at different times from different vendors, combine them in a different process, stock some items, ship others, and later find out that those items should be phased out. I am sorry, was that 10 items? I meant to say 100 items for one finished product? But 1,000 finished products were made. You get the picture because this is your day-to-day reality.

If the complexity in manufacturing arises from the coordination of many tasks, items, and people to a singular end, it follows that improved organization and rigid process controls that should allow for better coordination and improved inventory accuracy. How do we make that happen? Although there are a number of ways to describe best practices for inventory management, we are going to look at them in the following method:
  • Business-process design
  • Business-process control
  • Inventory validation
Business-process design
Business processes have to satisfy three criteria to be effective: satisfy the business requirements, be repeatable and reliable, and allow for appropriate tracking (for inventory, lot tracing, and accounting). Generally, for business processes to satisfy business requirements, the business must ensure that customers receive product in the appropriate form and on time within the appropriate tolerance levels. To be repeatable and reliable, the process must deliver the desired results as defined by the business requirements, consistently over time. Each time a transaction occurs in a business process, there is generally a corresponding need to track something. The key is that as a step in the process is executed, any attribute that is tracked in the process must be updated appropriately whether the tracking occurs on a pad of paper or a complex enterprise resource planning (ERP) system.

Business-process control
Strong business-process controls ensure that each step in a business process is completed in sequence before the next step is taken. For instance, assume a business process dictates the following steps beginning with the completion of manufacturing:
  1. Complete manufacturing.
  2. Receive into finished goods inventory.
  3. Ship finished goods.
In this instance, appropriate controls would not allow a product to ship prior to being received into finished goods inventory. In some respects, it seems trivial; however, it is not uncommon for products to move from the production floor to shipping. For some businesses, this may be appropriate, but with the process defined as it is here, shipment only occurs from finished goods inventory. If controls have been properly implemented, the only possible solution will be for products to follow the steps defined. The result of bypassing the controls in this system will likely mean inaccurate book inventory levels.

Inventory validation
Even the most perfectly designed processes will not produce perfect results due to factors such as variation in yield, inaccurate counting, or making mistakes while entering data. As a result, it is necessary to validate inventory occasionally. In the past, this was generally done with a tedious and time-consuming physical inventory, but best practices have evolved toward cycle counting. Cycle counting offers a number of benefits over physical inventory counting:
  • Continuous validation of inventory
  • Focus on materials that are of high value to the manufacturing process either because of their monetary value or because of their potential impact on the manufacturing operation as a result of inaccurate inventories
  • Performance of functions that are spread out enabling the resources used to perform the count to become specialists
  • Focus on determining the root of the inaccuracy so that it can be corrected
Finding the right ERP system
To help achieve best-business practices, keep in mind the following requirements for managing inventory when selecting an ERP system for your business:
  • Customized workflow — Workflow toolsets should allow for modifications to business processes that will accommodate special requirements unique to your organization.
  • Process controls — Controls should prevent users from circumventing established business processes, such as not allowing users to issue raw materials to work orders if they have not been received into on-hand inventory first.
  • Alerts — Customizable alerts should send messages to specified users if certain conditions are met, such as discrepancies with tolerance levels you have established at receiving points to prevent data entry errors.
  • Cycle counting — Cycle-counting systems should contain ABC analysis that allows users to easily group products into the correct categories, forms in paper or electronic format on hand-held devices to facilitate easy and effective cycle counts, and inventory accuracy reporting to help identify problem areas so that corrective action can be taken.
ERP systems such as Fourth Shift Edition for SAP Business One are proven, powerful tools in the quest for managing accurate inventory. In one instance, a company using this system reduced inventory variances (or the difference between reported and actual) from more than 30% to 2% within three months of installing the system.

I am not saying that it would not be helpful to be Superman when looking for a solution to your inventory accuracy problems — it is just not practical. Using business-process design, business-process control and inventory validation can lead you to a better solution. Having a great tool set in the form of an ERP system can turn a long-term struggle into a short-term success because of the business processes, controls and validations that are embedded in such systems. To achieve best-in-class performance, inventory accuracy is paramount.


Dan Sechrist is a founder of and partner in Thunderbird Consultants, L.P., a certified Fourth Shift Edition partner. He was previously the CFO at Fischer and Wieser Specialty Foods, Inc., where he led the selection and implementation of SoftBrands’ Fourth Shift Edition for SAP Business One. Prior to Fischer and Wieser, Sechrist worked as a consultant and employee in both operations and financial analysis roles. Throughout his career, he has participated and led process and systems projects.
space space space
Business One News
SAP ISV Partners Deliver Enhanced Management Solutions for Small Businesses
SAP ISVs have developed a number of add-on solutions that leverage the business-management functionalities of the SAP Business One application. Twenty new solutions have been certified to work with SAP Business One. Learn more.


See a Demonstration of SAP Business One
Discover how SAP Business One can enable people throughout your organization to gain business insight and perform their jobs more effectively. Learn more.


Subscribe to SAP Business Insights
Receive regular insights from high-profile business leaders and analysts, perspectives on technology strategy, and more. Subscribe today and receive a free white paper about Sarbanes-Oxley compliance. Subscribe today.
space

About SAP Business One
SAP Business One is an integrated, affordable business-management application designed specifically for small and midsize businesses. For the first time, business owners have a single system that automates their critical operations and offers an accurate, up-to-the-minute picture of their business.
Learn about SAP Business One.

1-866-609-6146   SAP
   
space          
space          
space    
Unsubscribe  |  Subscribe  |  Copyright/Trademark  |  Privacy  |  Impressum
   
space