Retail
Excel’s flexibility for inventory management, under IT governance
Retailers run inventory management on Excel templates that teams across the business fill in, from head-office departments to stores, because the business can change them whenever it needs to. Processes this important shouldn’t run on loose spreadsheets, which is why management and IT want them replaced. Excelerant keeps the templates and brings the process under IT governance.
Own copy
for every team, from one master template
Versioned
new templates tested before release, earlier versions kept
One place
where input is combined and the order files are generated
The challenge
Templates go out by e-mail and come back in different versions. Someone merges them and builds the order file on their own laptop, outside every control IT has in place. The usual answer is a project to replace Excel with a system, and the flexibility goes with it.
What Excelerant does
- Runs the templates as they are, macros and Power Query included.
- Gives every team its own copy in the browser, and records every change with who made it and when.
- Releases a new template from test to production, and keeps every earlier version.
- Reads in data from your other systems and generates the order files centrally, ready for your ordering system.
What you get
The business keeps the flexibility of Excel, and IT gets a process it controls.
Other business domains
Inventory management in Excel? See it run on your own workbook.
Or e-mail us at info@excelerant.nl