The wholesaler drowning in Monday-morning spreadsheets
A regional wholesaler runs sales through an accounting package, stock through a warehouse system and customer orders through email and a web shop. Every Monday, someone spends half a day exporting CSVs and assembling "the numbers" — and by Wednesday, nobody is sure which version is current.
Our approach
A one-week discovery to trace where every figure in the Monday report actually comes from, then a small warehouse receiving automated nightly loads from the accounting package, warehouse system and web shop.
What we would build
- Automated extracts from all three systems
- A modelled sales-and-stock warehouse
- A management dashboard refreshed daily
- A written definition for every metric
The outcome we design for
The Monday-morning assembly job disappears; the leadership team looks at one live dashboard with agreed definitions, and the person who used to build the report gets their half-day back.