The encyclopedia · Engineering & Operations · Operational decision · 2011–2015
Walmart.com picked an optimal box-size mix, cutting $600K a year and projecting $2M.
Walmart's Carrollton, Georgia DC used an Excel-based algorithm to choose the best mix of shipping carton sizes, certifying $600,000 a year in savings.
Walmart
the move
Walmart's online business grew quickly after 2006, so it built distribution centres to ship orders sold on Walmart.com. The Carrollton, Georgia DC handled a large share of orders sent to customers or to stores for pickup.
Because carton sizes were chosen by habit, the DC shipped orders in ill-fitting boxes, wasting material and shipping volume and driving up labour.
In spring 2011 the DC ran a cost-improvement project to optimise its carton mix. Working with managers and the corporate supply-chain team, analysts built an Excel-based algorithm to determine the optimal sizes for four automated and six manual cartons.
Walmart fully implemented the algorithm as a decision-support system for reconfiguring the mix, certifying $600,000 a year in order-fulfilment savings and projecting $2 million a year across the network.
why it works
- The order distribution, not the box catalogue, drives shipping cost
- Four plus six sizes is a small search space, so an Excel solver is enough
- A decision-support system lets the DC re-optimise as the order mix shifts
- Fitting more orders per carton cuts material, shipping and labour together
what transfers
In packaging the move is not a bigger box but a curated set of sizes that matches the actual order distribution, cutting material, shipping and labour at once.
what came after
Walmart embedded the solution algorithm into a decision-support system at the Carrollton DC, certifying $600,000 a year in order-fulfilment savings and projecting $2 million a year across the Walmart.com network. The Interfaces (2015) paper documented the process.
references
- Carton-Mix Optimization for Walmart.com Distribution Centers
- Carton-Mix Optimization for Walmart.com Distribution Centers
spotted an error? The archive wants to know.