Corporate Planning in Grocery Retail
Client
Large food retailer
Client problems
Implementation period
Integration
Low-quality planning and lack of detail
SAP
weeks
12
Description of the Client's situation:
Before implementing Spreadym, the client used Excel for forecasting, planning, and reporting.
The model was not integrated with the SAP, and plans from departments were collected manually.
The finance department spent about a week consolidating all data into the final report.
Manual calculation of revenue forecasts for operating stores
Manual data export from SAP and manual data collection from departments
Manual allocation of funds to logistics centers
Manual calculation of revenue and costs for planned stores
Before Spreadym
Results of Spreadym implementation:
Automatic and regular data exchange with SAP
Automatic calculation of revenue and expenses for the opening of new stores
Automatic revenue calculation considering seasonality, store lifecycle, and inflation
After Spreadym
Matrix for automatic allocation of projected retail revenue
