Bodybuilding.com needed to manage inventory more efficiently and prevent out-of-stocks.
They needed to quickly identify over- and under-performing items.
Driven by promotions
Better management of a highly promotional-driven environment was imperative.
The Demand Planning Compared Forecast to Future Orders alert captures any item exceeding the forecast and highlights ones that Bodybuilding.com will not be able to meet with inventory on hand and expected inbound orders. Bodybuilding.com runs this alert at the beginning of the week, then works with vendors to locate or produce more inventory as needed.
The Demand Planning Future Orders Percent of Resultant Forecast alert is run at the beginning and end of the week. The first run identifies items that are overselling either 50%, 80% to over 100% of the forecast. The second run, at the end of the week, identifies items that are underselling by 10%, 20% to 50% of the forecast.
To customize these alerts and prioritize items for investigation, the company leverages inventory segmentation analysis to identify A-B-C items. For example, one alert captures any high priority ‘A’ items where the forecast is exceeding future orders by over 100%. The company aligned the Logility alert thresholds—Critical, Warning, or Information—with the A-B-C codes, so for example, all A items have a severity bucket of critical. Global filters also enable planners to isolate classification of items and see those that are either new or active, and therefore able to be replenished.
Now when the system flags an issue, planners recognize it quickly. Bodybuilding.com Demand Planner Chris Halsted explains, “On Monday morning, I see all of the items that I need to investigate. I simply click a link to open the forecast hierarchy view. From there I can make adjustments, force them down if needed, and we can start buying.” Similarly, with underperformers, Bodybuilding.com can make a business decision to revise the forecast, or take a deeper dive and look at drivers and the impact on promotional activity.
Just 18 months after leveraging advanced analytics and activating alerts, backorders have dropped an impressive 45%, overstocks are down 10%, and total inventory is down by over 10%. “Our forecast accuracy has been improving month after month, and that’s a win-win situation for everyone, but especially our customers,” added Halsted.
Bodybuilding.com also used Logility to create new views of inventory trends that enhanced collaboration with suppliers. As a result of better planning and greater visibility, the company has reduced its US fulfillment center count from five to two locations. Leveraging Logility’s capabilities to adjust safety stocks and shift demand to fulfillment centers helps the business quickly reconfigure to the new distribution network. “We made major transitions without increasing our back order percentages,” says Halsted, “and it was very easy to do with Logility.”
Logility Demand Planning provides visibility across Bodybuilding.com’s supply chain network to increase forecast accuracy and right-size inventory levels.
Logility Inventory Planning allows Bodybuilding.com to improve inventory performance and customer support through demand and inventory plan alignment.
Logility Replenishment Planning helps Bodybuilding.com to isolate and manage inventory and service performance at a product-specific level.
With Logility, Bodybuilding.com was able to reduce backorders by 45%, inventory by over 10% and promotional pull–down by 50%. They increased forecast accuracy and were able to eliminate two DCs and pared safety stock without increasing backorder percentages.