Strategies for Effective Inventory Management

by Danielle Borges - Marketing & Sales Director

Today’s customers have an increasing expectation of an Amazon-level of transparency in all stages of delivery, even in the direct-to-business world. In order to streamline your workflows and create the needed level of transparency across your organization, from back office to the production floor, all the way through shipping, effective inventory management is the key ingredient for success. 

Although there isn’t a one-size-fits all approach to managing inventory, our CEO, Scott Love, recently shared some considerations for manufacturers in a recent webinar he presented for Claris, of Claris FileMaker. 

First Off: A Summary

Since most of us like a good executive summary, here’s a quick overview of the webinar: 

  • Considerations when choosing an inventory management system
  • Challenges he’s seen manufacturers face with inventory management
  • Examples of inventory management in action

Setting the Baseline: What is Inventory Management?

Most people see inventory as a way to track how much stuff you have purchased and how much stuff you have removed or sold from that stock. But as digital transformation takes hold, companies are rethinking what their technology and processes look like. As a result, inventory management becomes more about workflow. Now you have to ask yourself: “What do I want to do with that list?” 

Although it’s easy to rebrand inventory as a workflow problem, inventory challenges can run the gamut. Next, let’s explore how those challenges have manifested in the field based on our experience.

Inventory Management Challenges

Although no two inventory management scenarios are alike, many of them share the following issues. 

Complexities in the Supply Chain 

Many organizations work with a variety of vendors to get materials or products. There are two ways that this can happen: the easy way or the hard way. 

If an organization is just placing an order from a standard vendor, the process is simple. But it’s rarely so straightforward, particularly if you have a more complex product with international parts. Most organizations are trying to draw resources from multiple suppliers, so things like tracking quality, lead time, and customs delays all have to be factored into how the inventory is tracked and delivered to both internal and external customers. 

Measuring the Value of Your Inventory

There are different ways of measuring the value of your inventory. If you hold onto inventory for a long period of time, this becomes an important point when measuring the value of your business holdings. If you’re a company that deals with products that are interchangeable, like nails or sewing notions, each individual item is interchangeable with another. 

However, if you purchase products at different times, or at different prices, you’ll need to have a way to figure out the cost of inventory after you figure in those differences. Whatever inventory tools you choose must be able to do cost averaging across time, or you’ll need to track by attribute like bin, or price rank—another important characteristic.

Tracks Returns and Shrinkage

When someone mentions “inventory,” they often think of retail. And if you’re dealing with the retail industry, you have customer variables that will need to be tracked. Specifically, returns and theft. 

In the case of returns, organizations don’t often have a flexible method of returning inventory to stock outside of the direct-from-vendor relationship. 

In the case of theft from a showroom floor, it’s critical that your employees have a simple and efficient way to track shrinkage. Lacking portable, flexible systems leads to inefficient human resource time and results in dirty data. 

Common Inventory Technology Challenges

Staying connected to your production environment can be an amazing way to understand what challenges your team is facing on the floor and in the back office. As we’ve immersed ourselves into our clients inventory challenges, here is what pops up most often:

The Dreaded Spreadsheet If you’ve got piles of spreadsheets managing your critical information, it’s time to consider a unified system that distributes the most up-to-date information to all teams across the whole organization. 

Inadequate Inventory Software Too many organizations purchase expensive inventory or ERP solutions and only use 10% of the features available. Or worse yet, they rely on multiple, disparate homegrown systems made by enterprising employees, trying to create tools to help them do their jobs more efficiently. If this sounds like your organization, it’s time to consider custom software to give you the features you need across your organization.

Information Silos With information needing to be formatted in unique ways across systems, organizations often resort to double entry to make sure it’s done right. We see this often in the case of accounting. Concerned about security and data formatting, organizations feel this is the best approach, but in the end it’s time consuming with the potential for error.

Human Resource Cost When an organization comes across challenges with their inventory, it can be tempting to make up for inadequate technology with labor. When organizations rely on labor to wrestle with software, or type things manually across multiple systems, they are spending unnecessary monetary resources and drawing people away with repetitive tasks from higher value efforts.

Bridging the Divide with Technology

If you find yourself running into any of these challenges, there is a better way. Once you recognize the gaps in your process, you can apply both the technology and the problem solvers you want to be involved in a solution. For instance, at Codence, we tend to be the problem solvers, working with those who have identified the challenges. Then we use Claris FileMaker to create flexible, custom solutions to streamline your problem-solving process.

Inventory Problem Solving in Action

Here are a few examples using our custom approach to help give a sense for how this could work in the actual business environment.

Stitching Efficiency at an Embroidery Company

Company: An embroidery company that embroiders logos, slogans, and images on soft goods including hats, t-shirts, and other wearable items. 

Challenge: This embroidery organization uses thread to embroider soft goods. They buy thread in spools, but they consume it in yards. Some letters (like the letter G) consume more thread than others (like the letter S). Soft goods need to be tracked by size, style, and color. Customer goods can’t be added to the main inventory, but still need to be tracked by size, style, and color. 

Solution: Codence created three separate, non-interchangeable inventory systems. One more complex system allows operators to calculate thread use, order new spools, and calculate lead time to manage customer expectations. The next system tracks the inventory they are selling to customers to be embroidered, and the final system tracks the customer-provided inventory.

BANG, POW, BOOM: Comic Book Store Inventory Tracking

Company: A comic book shop that sells new and used comic books. 

Challenge: Vintage and used comic books are graded by quality. A copy of Batman 181 that is graded at a 9.4 is worth thousands of dollars while one that has been colored during a fit of creativity is not valuable. As a result, each item is a category of one and not interchangeable with other “like” items. The store also sells comics on consignment. 

Solution: This organization used a Claris FileMaker inventory app, to start, and then looped Codence in to help build upon and refine the app. The resulting inventory system acted as a way to keep track of their in-house inventory, and their customer inventory. It  also served as an alert to the retail associates on Slack when a rare item was added to the inventory that was also on a customer wishlist. Then the associate would use Twilio to text the customer.

Making the Stuff: Manufacturing Company Inventory

Company: A global manufacturing company that creates widgets that ship all over the world.

Challenge: This organization had facilities all over the country and the responsibility of managing the supply change. As they brought in materials from around the world, they were trying to create efficiencies on where the materials would be delivered, based on the part’s usage. If a part is to be assembled, it goes to California. If it’s going to be sold in New York, it’ll be delivered to storage at the Brooklyn Naval Yard. 

Solution: Codence created a visual map that integrated into Tableau. In this case, Claris FileMaker was fueling Tableau visualizations to ensure the right tool was being used for the right job. This offered clarity and transparency into which shipment would go where and helped ensure the company was saving both shipping costs and time.

Process Makes Perfect With Inventory Technology

When you start down the complex road of inventory management, take the problem one step at a time. Understand what your challenges are, identify who is going to help you solve that process, and recognize who your problem impacts. Consider prioritizing your challenges by evaluating money loss, time loss, or morale loss, and then make a roadmap for success. Add layers of sophistication along the way to ensure you’re able to “eat the whole elephant” (as the saying goes) over time. This will give you and your team confidence that there is an end and hope in sight. 

To learn more about how effective inventory management can elevate your business, watch our webinar and visit Claris resource page to get your free ebook. Together with Claris, let’s plan your route to success.

Subscribe to get the latest in your inbox.

This field is for validation purposes and should be left unchanged.

Leave a comment

Your email address will not be published. Required fields are marked *

Your email address will not be published. Required fields are marked *

Built with you in mind

Speak to one of our expert consultants about making sense of your data today. During
this free consultation, we'll address your questions, learn more about your business, and
make some immediate recommendations.


Stay in touch!

This field is for validation purposes and should be left unchanged.