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
InsightConsumer sector investment report: Trends and dataRead our in-depth look at the U.S. consumer market from the private equity perspective: Deal activity, M&A, sector-by-sector breakdowns, and more.
InsightTop 10 tips when preparing for a transactionSharon Bromberg, Daniel TeohBefore raising capital, consumer companies need to prepare for a potential transaction. Here are the top ten tips retail brands should consider when embarking on a merger or acquisition in the next 12 to 24 months. Read more.
InsightHealth & Wellness Investment Report: Q2 2022Daniel Teoh, Sharon BrombergM&A activity took a breather across all industries in Q2, the health and wellness sector experienced a bright spot with beauty deals. Download the report.