loading
I am available for work
logo

Hi, I'mMiranda de Freston

Designer & Developer

Vending Machine Management Tool

Category Systems

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.