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.
Marisa Garcia, Partner, CohnReznick Advisory
646-601-7786
Shachin Parker, Director, CohnReznick Advisory
858-926-3803
Stacie Jefferies, Senior Manager, CohnReznick Advisory
973-364-7842
Related Services
Integrated Business Planning
Optimize Inventory Management, Lower Workforce Costs & Improve Margins
-
InsightUsing a proactive pricing strategy to increase profitabilityJeff Wissink, Stephen WyssA proactive pricing strategy is essential for consumer businesses in this current inflationary environment. Learn more.
-
InsightM&A Advisor recognizes CohnReznick with Consumer Discretionary Deal of the Year AwardCohnReznick LLP, one of the leading advisory, assurance, and tax firms in the United States, today announced that it won The M&A Advisor’s Consumer Discretionary Deal of the Year Award (under $100MM) as part of the organization’s 14th Annual International M&A Awards
-
Press ReleaseSachs joins CohnReznick as Assurance PartnerScott Sachs has 20 years of audit experience serving large and middle market private equity and public company clients in the M&D and consumer industries.