Category Archives: Inventory

Algorhythm: Still Pounding Out the Optimization Rhythm on the Tabla (Part II)

In Part I, we re-introduced you to Algorhythm, purveyors of a supply chain optimization rhythm solution platform out of Pune. In the day before yesterday’s post, we discussed their new Inventory Planning Module, inventrhythm, and indicated how it allows you to take your entire distribution network design into account, which is necessary if you truly want to minimize your inventory costs. Then we told you that if you were truly serious about getting the most bang for you inventory dollar, you had to go beyond inventory and also consider your underlying distribution network design, as it ultimately dictates how much your inventory is going to cost you. Just like a bad product design will lock in expensive commodity and engineering costs before it is sourced, a bad network design will mandate higher safety stocks and sub-optimal transportation methods, which will in turn lead to higher carrying and transportation costs. Thus, to truly optimize your inventory, you also have to simultaneously optimize your distribution network to the extent that you are able to do so.

With Algorhythm’s new Strategic Distribution Network Optimizer, which seamlessly integrates their netrhythm supply chain network design module with their new inventrhythm multi-echelon inventory optimization solution, you can simultaneously optimize your facility location, transportation methods, and inventory levels to achieve your end-customer service levels while minimizing your overall inventory-related supply chain costs.

Algorhythm’s netrhythm solution allows you to define the warehouses that are available to you at each level of your network (and to define the warehouses that must be used, or must not be used, in the solution) in addition to source factors and end customer locations; the transportation methods available; the transportation providers available (as well as any that must be used, or must be used, and minimum or maximum business levels); fixed, minimum and/or maximum lot sizes; available lanes, forecasted demand; target inventory levels; and network constraints (with respect to linkages, warehouses, product mix, mode, etc.) and produces a lowest cost distribution network design subject to your constraints that will achieve your target service levels at each location. In other words, it’s a very powerful network design model that lets you take all of the relevant components in your physical network.

But the integrated solution is even more powerful. In addition to the many layers of your distribution network, transportation modes, and logistics providers, you can specify detailed service targets by location, SKU, and period. You don’t have to use average demand levels — you can take into account your detailed forecasts by month, week, and even day. You can model all of your inventory related costs at different demand levels; segment inventory by SKU subgroup, group, and category; and analyze by cluster and channel. You can look at your various cycle times, load factors, and flow options and do so with respect to all of your network and inventory constraints (such as capacity and existing agreements) and cost components (fixed and variable). For example, you can take into account fixed truckload and variable less than truckload rates from a third party and compare that with fixed and variable costs of operating your own fleet (lease, maintenance, etc.). And when you’re done, you get the network design that minimizes your inventory levels and associated costs while ensuring that your service levels are met. The reports detail what inventory levels are needed where, when, and the replenishment cycles as well as what providers move the product, when, using what modes, and at what load factor. It’s a complete supply chain plan. Furthermore, it’s easy to work with because all the reports can be output to Excel — which allows you to drill and pivot to your heart’s content until you see the data in a form that’s most convenient for you to internalize. (And while spreadsheets are not supply chain solutions — especially where optimization and analysis is concerned, they are good for report manipulation, and everyone is already comfortable with them.)

And the results are beyond what you would get with either tool on its own because not only does your distribution network dictate your inventory costs, but changes in inventory requirements over time will dictate your network costs. (If a warehouse becomes unnecessary because customer locations move and new lanes open up, that’s a considerable fixed cost that is unnecessary.) It’s a viscous cycle, and unless you look at both in unison on a regular basis, you’re missing cost reduction opportunities. Consider the case study of a major (FM)CG company in India that typically maintained about 115 tonnes of inventory in its network in an attempt to meet service levels. Not only did every tonne of inventory, depending on the SKUs in question, represent anywhere between roughly ten thousand and a few million dollars of working capital tied up in inventory, but every tonne represented additional inventory costs that chipped away at margin and profit. When Algorhythm applied their basic SKU inventory model, they were able to present the CG company with a solution that trimmed 25 tonnes of inventory out of the system without affecting service levels. (In fact, the average service level was increased!) When they moved to a multi-echelon inventory model, which balanced inventory not just at each level, but across levels (and allowed inter-level shipments as well), they were able to trim an additional 26 tonnes of inventory. But when they applied the full Strategic Distribution Network Optimization model, they were able to shave an additional 5 million tonnes. In the end, they more than halved the required amount of inventory to meet the service levels, and halved the network related costs. That’s a very considerable chunk of change that went straight to the bottom line!

Share This on Linked In

Algorhythm: Still Pounding Out the Optimization Rhythm on the Tabla (Part I)

Since I last covered Algorhythm and their supply chain optimization rhythm, they’ve been pounding out a steady beat and extending the breadth and power of their unique supply chain optimization platform. Not only do they have extensive optimization capabilities in production planning, network planning, and logistics planning — with specialized solutions for oil, steel, and packaging, but they now have a best of breed multi-echelon inventory optimization capabilities and a best of breed distribution network design optimization platform that can take multi-echelon inventory requirements into account and allow you to optimize your distribution network around your detailed inventory requirements, which can be specified at daily demand levels if you desire. This is a very powerful capability that sets their platform apart from the other solutions on the market, as most of the other supply chain optimization platforms focus on inventory, or network design, but not both simultaneously.

To understand just how powerful their new solution is, we have to start by discussing how hard it is just to optimize inventory. There’s a lot more to inventory than just the carrying cost that is recorded on the books. There’s the cost of replenishment, the cost of a stock-out, and the cost of missed service levels, for starters. If your planning is poor and you’re always having to rush inventory, or if you’re not maximizing truckload volume, you’re spending a lot more on inventory replenishment than you should be. If a stock-out results in lost sales, that’s missed revenue opportunities which go straight to the bottom line. And if you keep missing your service level targets, your customers might just find a new source of supply at contract renewal time. (And on the flip side, if you are constantly carrying too much inventory to make sure you don’t miss service levels, your carrying costs will go through the roof.)

To optimize inventory, you have to take into account the many layers of your distribution network: factories, (first tier) national warehouses, (second tier) regional / provincial warehouses, and (third tier) local warehouses; storage space at each location; valid flows from one tier to another, as well as valid flows between nearby warehouses at the same tier; transportation options available; stores or end-use facilities that require the SKUs; the individual SKU demand patterns (and [expected] forecast accuracies); lead times (and variabilities); service levels; and costs associated with storage, transportation, and stock-outs at various inventory levels. (Transportation costs in particular will vary.)

This is because you don’t need the same service level at every node in the network to achieve that service level at an end customer location, especially if a customer location can be serviced by multiple distribution centres. For example, if an end customer location can be serviced by three different distribution centres, you can achieve a 98% service level (defined in terms of SKU availability) as long as each individual distribution centre has a 75% service level (as the chance of all three distribution centres being simultaneously out of stock and unable to service the customer location is 0.25 * 0.25 * 0.25 or 1.5625%). Furthermore, as the lead time from each DC to each customer location will vary depending upon distance, transportation options, and local routes, and so on, the inventory levels at each DC can vary and still allow you to meet your target service levels, which can in fact vary by location (as you’ll want a higher service level at a high-profit location than you will at a low-profit location as service levels drive inventory which drive costs). In fact, the deeper you dive into inventory, the more complex the cost equation becomes and you see that you really do need to take into account all of the elements supported in the Algorhythm Xtra Sensory Inventory Optimizer, inventrhythm, if you truly want to optimize your inventory costs.

But this is just the beginning. Since your distribution network design will ultimately dictate your inventory costs, to truly optimize your inventory costs, you have to simultaneously optimize your network (to the extent that you are able). Algorhythm’s platform can do this, and we’ll discuss what’s involved in Part II.

Share This on Linked In

A Quick Reference to Perfect Order Fulfillment in Your Warehouse

I enjoyed the recent white paper from Motorola on Warehouse Management: A Quick Reference Guide To Improving Inventory Accuracy For Perfect Orders because it was short and got straight to the point. Defining the perfect order as an order that is

  • delivered on time and in full,
  • in compliance with a customer’s three-way match (invoice, PO, and receipt), and
  • free of quality issues,

it goes on to say that multiple factors contribute to imperfect orders and that the most important starting point is a value stream map that identifies where the most errors are occurring in your current operations.

It then presents some straight-forward resolutions to common operational challenges that you can use to quickly increase your perfect order accuracy. Examples include:

Operational Challenge Resolution
Manual Order Processing & Improvement automation technology, RFID, barcodes, and mobile printers
Picking Methods hands-free wearable computers, scan verification, and voice recognition
Software Systems central database/ERP, WMS module, continuous training and improvement
Labor include employees in improvement processes, reward workers for achieving goals, communicate regularly, and hold everyone accountable for following the right processes

Share This on Linked In

Inventory Accuracy Isn’t Rocket Science! Why Are You Still in the Dark Ages?

A recent article in Supply Chain Digest on Measuring Inventory Accuracy started off by nothing that the experts are saying that there’s no clear answer because there are so many ways to calculate inventory. WTF? Did I read that right?

The article then went on to say that the editorial staff at Supply Chain Digest did some informal networking and found that the answers were all over the map. Really? Who did they ask? Cave Trolls? We’re not in the supply chain dark ages anymore or, at least, we shouldn’t be.

So what did the editorial staff find in their investigation for an inventory accuracy calculation which defines the expected variance between book inventory and actual count? They found:

  • Jim Tompkins of Tompkins Associates offered the following formulas:
    • Financial: (Reported/counted Value inventory-System inventory Value)/Expected inventory value
    • Operational: Total inventory UOM Variation/Total Expected Inventory
    • Locational: Number of locations with variances/Total locations
  • Dave Piasecki of Inventory Operations Consulting noted that:
    every accuracy measurement is flawed in itself in that it can’t by itself show you a true picture of your accuracy and that you have to devise an appropriate “composite score”
  • Ken Miesemer of St. Onge recommends:
    cycle counts by location or geographic counts (an aisle or two at a time)
  • Doug Baker of Istoner states that:
    they rely on absolute and net dollar variance as well as unit variances from the cycle count processes

Ugh! I don’t get it. I know each of these experts has heard of RFID and the Internet and should know that this isn’t a hard problem anymore. At a high level, here’s what you do.

  1. Slap an RFID on each shipping unit — be it a unit, box, or palette — as it’s produced and enter it into the system.
       Now you know how much you’ve produced.
  2. Each time it enters or leaves a location, scan it.
       Now you know how much should be at each location.
  3. Use a supply chain visibility solution to link up with your retailer’s POS systems and have them upload a feed of units sold every day.
       Now you know how much is left at the retailers and you instantly know, at any time, the upper limit of how much inventory you have in the chain. Actual inventory is last count minus sales since last POS feed minus theft since last physical count.

Now, if you also use the system to track thefts and calculate average historical theft rate by SKU category (by day) and average daily sales rate, at any time you can produce an inventory count that is expected accurate within the sum of the (daily) theft variance and sales variance. Pretty easy, eh? And all you have to do is use the modern supply chain technology systems you should have been using for at least the last half decade. Any questions?

Share This on Linked In

B2B Connex: e-Document Management for Small & Mid-Size Manufacturers

B2B Connex provides a web-based sourcing and procurement document management solution that is a great fit for all types of small and mid-size manufacturing organizations that need simple e-Sourcing and e-Procurement functionality at a low price tag. It’s basic portal solution, that plugs in to your existing ERP & MRP solution, can be acquired for as little as $30,000 (plus 20% annual maintenance) for a small operation. Mid-size operations are generally priced by the number of locations and users, but even their larger customers don’t pay much more than 100K. (Pure SaaS configurations and pricing are also available, but most of customers with traditional on-site ERPs/MRPs generally prefer on-site installations.)

Designed to fill the niche in the small and smaller mid-sized business market left by the big end-to-end e-Sourcing and e-Procurement suite vendors whose solutions often come with a big price tag, the B2B Connex solution allows you to easily manage the following e-Document types (among others) and efficiently conduct your day-to-day procurement operations.

  • RFQs
  • Purchase Orders
  • Kanban Orders
  • Shipment Notices
  • Payment Inquiries
  • Invoices

In addition, it can also handle the CRM side of your business and allow you to manage the following e-Document types (among others):

  • Inbound RFQs
  • Sales Orders
  • Inbound Shipment Inquiries

It’s implemented as a simple web-based portal solution, that can be accessed as needed by your procurement personnel, and it integrates with your back-end ERP and/or MRP systems. (Right now, they support about a dozen ERP/MRP systems with no or minimal configuration work, including SAP, Oracle, JDE, Intuit, Avantis, and Mapics.) And since it handles all the key document types, it allows you to do m-way matching and insure that the invoices are accurate (and represent actual shipments and agreed upon pricing) before you pay them. Since the lack of this capability is one of the two biggest reasons that up to 60% of negotiated savings never materialize (with the other being maverick spending), it’s a good one to have!

In addition to document status (such as new, acknowledged, reviewed, accepted, etc.), the system also supports state management, and a supplier can, for example, accept, reject, or mark each line item for negotiation on a purchase order. This is a useful feature for spot buying, which is common for MRO, SG&A, and low dollar spending in smaller organizations. Also, each e-Document can have an unlimited number of e-Document attachments, so your RFQs can contain detailed item descriptions and sample contracts and your purchase orders can contain detailed specifications and shipment terms and conditions, etc.

If you’re a small or smaller mid-size manufacturer still on EDI and holding off on an e-Procurement system because you think it’s too extensive for your needs, or you think it won’t integrate with your ERP/MRP, or you think you’re too small for such a solution, it’s certainly a system you should check out. Plus, they have an ROI guarantee. If the system does not pay for itself in a year, they’ll refund the purchase price. However, considering the implementation of even a basic e-Procurement e-Document management system such as this generally comes with at least a 25% productivity improvement across your Procurement department, it’s pretty hard not to see savings (especially since the automatic matching will reduce payment errors and the built-in e-Negotiation capabilities on spot buys will help you get price reductions).

Share This on Linked In