Latest / The Operator's Manual with Fexingo: Daily Decisions, Tactical Wins, and Business Execution / Inside the Multi-Billion Dollar Inventory Game at Walmart
Transcript
- Lucas: Walmart holds roughly two weeks worth of inventory across its entire US network. That's down from about six weeks in the early 2000s. And that shift — from 45 days of inventory to under 30 — has freed up something like eight billion dollars in cash that would otherwise be sitting on shelves. Luna: Eight billion. That's not just efficiency — that's a competitive weapon. Lucas: It really is. And the metric that matters here is something called inventory velocity — basically how fast you sell what you have and replace it. For Walmart, every single day they can shave off that holding period translates to roughly four hundred million dollars in freed cash. Luna: So if you cut ten days, that's four billion? That's staggering. But how do you actually do that at scale? I mean, Walmart operates over ten thousand stores globally, each carrying maybe a hundred and twenty thousand different items. Lucas: Right. The answer is a piece of proprietary software called Retail Link. It's been around since the 1990s, but it's been continually upgraded. Essentially, it gives every supplier — from Procter & Gamble to a small local food producer — direct access to Walmart's point of sale data in near real time. Luna: So the supplier can see exactly what's selling at which store, and when to ship more. That shifts the inventory burden back up the supply chain. Lucas: Exactly. Walmart doesn't place purchase orders in the traditional sense. The supplier is responsible for maintaining agreed-upon inventory levels. If a store in Tulsa sells through its Tide detergent faster than expected, the system alerts the supplier, and they ship more. Walmart only pays for the goods once they hit the shelf. Luna: That's incredible leverage. But it also means the supplier has to be incredibly responsive. Not every manufacturer can do that. Lucas: And that's part of Walmart's edge. They essentially force their suppliers to adopt their operating rhythm. The ones that can't keep up get delisted. But the ones that do get massive volume in return. It's a high-stakes partnership. Luna: Let's talk about the trade-off though. In 2022, Walmart had a well-publicized inventory problem. They over-ordered during the pandemic supply chain crunch, and then demand shifted. They ended up taking about three billion dollars in markdowns to clear excess inventory. Lucas: That was a painful lesson. Walmart's inventory to sales ratio jumped from about 11 percent to over 14 percent in the first half of 2022. They had too much stuff that people no longer wanted at full price. But here's the thing — they caught it quickly. By the third quarter, they had already slashed orders and were liquidating. Luna: Contrast that with Target. Target had a similar problem, but they were slower to react. Their markdowns were even bigger relative to revenue, and their stock took a much harder hit. Lucas: Target's inventory issue was about two billion dollars in excess, but their revenue base is smaller. And Target operates more like a traditional retailer — they buy inventory centrally and push it to stores. Walmart's supplier-managed model gave them more flexibility to cut orders fast because the suppliers were holding the risk. Luna: So the system that works in normal times also helped in a crisis. But is there a downside to pushing inventory risk onto suppliers? I mean, what if a key supplier goes under? Lucas: That's a real risk. Walmart has to be careful not to squeeze suppliers so hard that they become financially unstable. There have been cases where small suppliers went bankrupt because Walmart's payment terms — typically 30 to 60 days — combined with the inventory holding costs were too much. Luna: And that's where Amazon's model differs. Amazon holds a lot of inventory itself in its fulfillment centers. They use algorithms to predict demand and pre-position stock. But Amazon's inventory turnover is actually slower than Walmart's — about 45 days versus Walmart's 28. Lucas: That's a key point. People assume Amazon is the most efficient, but Walmart's physical store network acts as a distribution hub. When a customer buys something in a store, it's instantly sold and replenished. Amazon has to ship from a warehouse, which adds a day or two. But Amazon's advantage is product selection — millions of SKUs versus Walmart's hundred thousand or so. Luna: So Walmart wins on velocity for the items they carry, but Amazon wins on breadth. Different trade-offs. Lucas: Exactly. And Walmart is trying to bridge that gap with their marketplace and with services like Walmart Fulfillment Services, which lets third-party sellers use Walmart's logistics. But their core advantage remains the in-store replenishment rhythm. Luna: Let's zoom in on a specific number you mentioned earlier: one day of inventory equals roughly four hundred million in cash. How do you calculate that? Lucas: It's straightforward. Walmart's annual cost of goods sold is about four hundred and twenty billion dollars. Divide that by 365 days, and you get about one point one five billion dollars per day of inventory cost. So every day you reduce inventory holding, you free up that much cash. But not all of it is pure cash savings — you have to account for the cost of carrying inventory, which includes storage, insurance, and capital costs. The net benefit is around four hundred million per day. Luna: That's still enormous. And it explains why Walmart invests so heavily in data systems and logistics automation. They recently opened a massive automated distribution center in Texas that can handle two million cases per day. Lucas: Those automated centers are a key part of the next phase. They use robotics to unload trucks, sort items, and build mixed pallets for stores. The goal is to reduce the time from supplier dock to store shelf by another two to three days. If they achieve that, that's another billion-plus in freed cash. Luna: But there's a ceiling, right? You can't go to zero inventory. You need safety stock to handle demand spikes or supply disruptions. Lucas: Right. The optimal inventory level is a balancing act. Too little, and you face stockouts — lost sales and angry customers. Walmart estimates that a one percent stockout rate costs them roughly three hundred million dollars in lost revenue. So they have to be surgical about which items need buffer stock and which can run lean. Luna: And that's where machine learning comes in. Walmart uses predictive models that factor in weather, local events, even holidays to forecast demand at the store level. Lucas: Yes. For example, before a hurricane, stores in the affected region automatically increase inventory of water, batteries, and plywood. That's not intuition — it's a model that has been trained on decades of sales data. Same for seasonal items like grills in summer or shovels in winter. Luna: It's almost like a financial trading desk, but for physical goods. You're managing a portfolio of inventory with different risk profiles. Lucas: That's a great analogy. And the best operators treat inventory as a portfolio. Some items, like basic groceries, have predictable demand and low margins — you want to run those very lean. Others, like electronics or fashion, have higher margins but unpredictable demand — you might carry more buffer, but you also have to be ready to mark down quickly if they don't sell. Luna: So what's the one takeaway from Walmart's playbook that any business — not just a retailer — can apply? Lucas: I think it's the idea that inventory is not an asset; it's a liability in disguise. Every dollar sitting on a shelf is a dollar not earning a return. The goal should be to have just enough inventory to meet demand, and no more. That requires real-time data, close supplier partnerships, and a culture that values cash flow over gross margin. Luna: And a willingness to make painful cuts when you misjudge demand. That 2022 markdown was a three billion dollar lesson. Lucas: Right. But even that mistake was contained because the system allowed them to see the problem early and react. That's the ultimate operational advantage — not avoiding all mistakes, but catching them faster than anyone else. Luna: So the next time I walk into a Walmart and see a shelf fully stocked, I'll remember that behind it is a multi-billion dollar data and logistics operation. Lucas: And a supplier somewhere who just got a real-time alert to send more. That's the invisible machine that makes retail work.