Retail Inventory Method Calculator
In February 2024, Macy’s CFO Adrian Mitchell told investors the company had fully converted from the retail inventory method to cost accounting. A month later, Nordstrom’s CFO Cathy Smith said her company would transition as of that fiscal year. Supply Chain Dive, reporting on the shift on 19 December 2024, listed the large retailers who stayed put: Dillard’s, Target, Walmart, Kohl’s, J.C. Penney and Dollar Tree. Citing PwC, the same report noted that nearly a third of the National Retail Federation’s top 100 still use the retail method to some extent, about a quarter of them using only the retail method and the rest running a hybrid. So the method is not obsolete and it is not unimpeachable. It is a working estimate with one known distortion, and that distortion lives almost entirely inside a single decision most operators make without noticing they have made it: whether net markdowns belong in the denominator of the cost-to-retail ratio. That one choice moved the answer by 6.1 percent in the worked example below, on identical inputs. In a heavy clearance quarter it moved it by nearly 17 percent. This calculator runs all three standard variants at once so the choice is visible rather than buried in a spreadsheet someone inherited.
Ending Inventory at Cost = Ending Inventory at Retail × Cost-to-Retail Ratio