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.