Improving financial forecasting – and profits – with retail-ready analytics
The retailer asked CohnReznick to help it implement automated tools and processes to better monitor inventory and plan forecasts across widespread U.S. locations, business units, and teams. Our advisory team suggested an Integrated Business Planning (IBP) strategy that unifies people, processes, and technologies for financial budgeting. We first met with the retailer’s planning stakeholders to better understand forecasting needs, current processes and technologies, and business operations.
Next, we created a single-merchant open-to-buy tool to help the retailer automate and manage inventory across its seven e-commerce websites. The tool enables planners to track sales, profit, and inventory at the subcategory level for a rolling 18 months. We configured the system to measure performance across all websites and roll up to an across-the-board total. Planners can evaluate performance across brands in a single system, and pass along unit sales and inventory forecasts to the supply chain team for estimating capacity and labor needs.
CohnReznick also implemented an assortment-planning tool that allows the retailer’s apparel team to analyze past-season sales of categories and items to accurately determine demand for upcoming shopping flashpoints. The tool uses advanced statistical forecasting to predict the sales curve for each item and recommend a weekly item-level sales plan, which is especially helpful for gauging sales performance of seasonal SKUs. We also implemented promotional-planning capabilities that identify items sold at extreme markdown – think Black Friday – and calculates the impact of these sales on overall sales and profit goals. The flexible tool allows the retailer to adjust the margins of promoted items to improve outcomes. We also created an environment for no-sweat collaboration and exploration of whatif analyses associated with various scenarios.
The unified IBP solution has enabled the retailer to lower inventory and workforce costs, reduce stockouts, and enhance margins. Planning staff can now more accurately forecast sales, profit, and inventory for a rolling 18-month period across all websites.
This has enabled the planning team to generate forecasts on a weekly, rather than monthly, basis and has eliminated a threeweek communication gap between the merchant and supply chain teams. What’s more, the IBP solution has sharpened forecasting precision to within 6% accuracy, compared with a previous average of 15%. This enables more precise downstream planning, and has driven down shipping delays and delivery costs. At the same time, elimination of manual processes associated with maintaining and uploading 2,000 spreadsheets has improved employee productivity and job satisfaction.
The unified system also enabled the retailer to trim inventory on hand from 12.5 weeks in 2017 to an average 9.76 weeks in 2018, a 22% improvement. As a result, the retailer saves on warehouse, facilities, and labor costs while simultaneously expanding sales. The company predicts that profits will climb an additional 19% in 2019, which would enable it to boost profits by almost $1 billion over two years.
Integrated Business Planning
Optimize Inventory Management, Lower Workforce Costs & Improve Margins
InsightYear-end tax planning opportunities for the consumer industryJoel Boff, Corey RosenthalTax laws are constantly changing, and this means the consumer products industry needs to be aware of certain opportunities and concerns as they close out the year. Learn more.
InsightHealth & Wellness Investment Report: Q3 2022Daniel Teoh, Kim Clark-PakstysWith deal count and total investment amounts dipping in Q3 in the health and wellness space, we’re providing performance improvement strategies in our Health & Wellness Q3 Investment Report. Download the report.
InsightManufacturing & Distribution M&A Quarterly: Q3 2022Helana Robbins Huddleston, Matt HennessyIn our Q3 M&D M&A Quarterly report, we review transactions in the capital markets space, data due diligence, mergers and acquisitions, and more. Download the report to learn more.