Our client needed a solution for managing the data from their vending machine business. The entire system was managed on paper and one very simple spreadsheet – the client could not get the analysis they needed and also were bogged down in extensive admin.
Working with them to understand the business we built a tool within Excel which gave them the tools they needed to manage the business. They could:
- Identify profitability of individual lines
- Pick Sheets so that it was easier to re fill machines
- Week by week analysis of individual machines performance
- And much more…
The vending machine business was sold a year after implementing the tool, having the data and tool allowed our client to show the full workings of the business, its profitability and handover a tool allowing the new buyer to easier run the business.
Excel is a powerful tool which where used appropriately can really help optimise your business.