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:
used Excel for forecasting, planning and reporting.
Prior to implementing Spreadym,
the Client used Excel for forecasting, planning and reporting.
the Client
The model was not integrated with the SAP accounting system;
plans from
departments were collected manually.
plans from departments
consolidating all data into final report.
consolidating all data into final report.
about week
The finance department spent
consolidating all data into final report.
Manual calculation of revenue forecasts for operational 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
Automatic and regular data exchange with SAP
Automatic calculation of revenue and expenses for the opening of standard stores
Automatic revenue calculation considering seasonality, store lifespan, and inflation
Matrix for automatic allocation of forecast retail revenue
Before Spreadym
Results of Spreadym implementation:
After Spreadym