Bookkeeping Pitfalls

Strategies For Effective Inventory Management

Inventory is a key balance sheet item for many organizations. Depending on the nature of your operations, inventory may include raw materials, work-in-progress (WIP) inventory, and finished goods. While you need to have enough inventory on hand to meet your customers’ needs, having excess amounts can be costly. Here are some ways to effectively manage inventory — without compromising revenue and customer service.

Reliable Counts For Inventory Management

Effective inventory management starts with a physical inventory count. This exercise provides a snapshot of how much inventory your organization has on hand at that point in time. For example, a manufacturing plant might need to count what’s on its warehouse shelves, on the shop floor and shipping dock, on consignment, at the repair shop, at remote or public warehouses, in transit from suppliers, and between company locations.

The value of inventory is always in flux, as work is performed, and items are delivered or shipped. To capture a static value as of the reporting day, organizations may “freeze” operations while counting inventory. Usually, it makes sense to conduct counts during off-hours to minimize the disruption to operations. For larger organizations with multiple locations, it may not be possible to count everything at once. So, larger organizations often break down their counts by physical location.

Accuracy is essential to knowing your cost of goods sold, as well as to identifying and remedying discrepancies between your physical count and perpetual inventory records. Possible reasons for discrepancies include:

  • Data entry errors,
  • Inaccurate bin or part numbers,
  • Shipping errors,
  • Inventory in the authorized possession of employees (such as owners or salespeople),
  • Theft, and
  • Intentional financial misstatement.

It’s important to identify what’s happening and resolve any problems or errors.

Benchmarking Studies

The next step is to compare your inventory costs to those of other organizations in your industry. Trade associations often publish benchmarks for:

  • Gross margin [(revenue – cost of goods sold) / revenue],
  • Net profit margin (net income / revenue), and
  • Days in inventory (annual revenue / average inventory × 365 days).

Your organization should strive to meet — or beat — industry standards. For a retailer or wholesaler, inventory is simply purchased from manufacturers. But inventory is more complicated for manufacturers and construction firms. These entities must allocate costs to projects that are in progress.

Efficiency Measures

What can you do to improve your inventory metrics? The composition of your organization’s cost of goods will guide you on where to cut. In today’s tight labor market, it may be difficult to reduce labor costs. But it may be possible to renegotiate prices with suppliers.

And don’t forget the carrying costs of inventory, such as storage, insurance, obsolescence, and pilferage. You can also improve margins by negotiating a net lease for your warehouse, installing antitheft devices, or opting for less expensive insurance coverage.

To cut your days-in-inventory ratio, compute product-by-product margins. You might stock more products with high margins and high demand — and less of everything else. Consider returning excessive supplies of slow-moving materials or products to your suppliers, whenever possible.

Product mix can be a delicate balance, however. It should be sufficiently broad and in tune with consumer needs. Before cutting back on inventory, you might need to negotiate speedier delivery from suppliers or give suppliers access to your perpetual inventory system. These precautionary measures can help prevent lost sales due to lean inventory.

Inventorying Your Inventory

Management often focuses on growth and puts inventory management on the back burner. This can be a costly mistake. Contact us for help researching industry benchmarks and calculating inventory ratios to help reduce the guesswork in managing your inventory.

Related Articles

Talk with the pros

Our CPAs and advisors are a great resource if you’re ready to learn even more.