Following from my last blog, once the decision was made to remove the need for business premises, I wanted to make sure the process we used to receive bookings was efficient.
The process used in 2005 was different to what we use today – mostly because of the volume of work we now manage. The technology we employ was a little different back then too.
Over time, our process has changed, improved and evolved in to the efficient system we have today. The Japanese have a word for this process of constant gradual improvement and it is known as Kaizen.
Initially, there were benefits to using online booking forms but I didn’t really think about how the information we received would be used to communicate and what the full process flow of that information would be. For example, I didn’t really think about invoices in too much detail. I never thought about tracking customer trends, or Key Performance Indicators.
Going back to day one, we had an online booking form that would send a formatted email with a customers journey details. This would include the date, pick-up times, number of passengers etc. The information from that email was then copied manually in to a spreadsheet and while there was only myself as the driver, this worked fine. Things began to change though as the volume of bookings increased and the number of invoiced accounts improved. Imagine how long it would take at the end of each month to sort out all the bookings for one single client and then put them on an invoice.
From here, there were a number of steps I went through to build a system that could manage the administrative side of the business – in a later blog I plan to talk about vehicles, drivers, chauffeur etiquette and all sorts of things about being out on the road but first, it is essential to get the foundation in place.
A business cannot operate efficiently unless it is managed appropriately.
The first step in the chain was to move all bookings from a spreadsheet and in to a database so filters could separate information and group specific details together for invoicing – journeys for customer A, B or C between dates X and Y. Next, the reporting function of the database was used to construct a formatted invoice that could be exported to a recognised file format and emailed to a client as an attachment (printing everything out became a nightmare as our volumes increased, there was paper everywhere).
I realised a filter could be used to produce a list of future journeys that a driver had planned. These journeys could be listed in a report, then exported as a web page and uploaded to a secure area of our web site. Now a driver only had to check on their own web page to see which jobs they had coming up. This was great if we were all working different shifts and asleep at different times. I also realised that if a drivers journeys could be filtered, exported and uploaded so too could a customers journeys.
At this point, things really started to become much more technically involved and we approached our first software developer. He linked the email through some clever programming and it put the booking from the web page straight in to our database system thus automating the bookings and reduced the need for manual copying (which incidentally removed the opportunity for errors to occur).
The database system we now had made our entire operation much easier to handle. If we had an enquiry from a customer who travelled two years earlier, we could retrieve all the details within seconds. However, there was still one major problem and that was that we could not alter a journey unless we were sitting in front of the computer. The next improvement introduced “remote desktop”.
Eventually we felt we developed our system as far as it would go and the next stage was to hand it over to a professional software company.
They could make it a web based booking system – basically a database that runs on a web server that drivers and customer can access 24 hours a day. The added bonus with this is that our manager’s had a new interface which meant they now manage bookings directly from their mobile phone (in real time).
No comments:
Post a Comment