Case Study: TMS Motor Group

Business Need

Real World Analytics (RWA) is delighted to announce that TMS Motor Group has chosen RWA as their Business Intelligence (BI) partner. The main challenge that this dealer group had was the substantial time their management used to spend on collating data from numerous spreadsheets in order to get a wholistic view of their business and make good decisions. Following their research of BI solution providers and their trial of a number of them, TMS decided to work with RWA and they have already been getting good results through the solution.

TMS Motor Group primarily operate their business based on information that comes out of their Dealer Management System (DMS). Additional reports which were needed required extraction of data from their CDK Rev8 system, which was difficult. They also needed to bring this information together with their eDynamix aftersales solution, DealerWeb lead management solution as well as their budgets and manufacturer targets. On top of all that, they wanted to free up their management’s time who otherwise would spend one full day per week collating this information.

www.tmsmotorgroup.co.uk

Solution

The RWA Auto Team put together a plan based on the needs of each of TMS’s departments that would deliver the business objectives for the Sales and Aftersales departments as well as providing company-wide performance information to the senior executives.

TMS worked together with RWA to create automated DOCs for each department. While RWA has a general DOC for each department, these were customised with TMS’s directors to ensure that the information being sent out to the managers was the key information they needed to run their business on a daily basis. The DOCs give an overview of their financials vs budgets, as well as any stock information necessary and exception reporting. This allows for any issues to be nipped in the bud quickly, giving managers more time to work on driving their sales and cost management.

In the first few months of the systems implementation, TMS found great use for RWA’s reporting around the workshop and technician clocking. The level of detail provided by RWA’s clocking detail which went to technician level at all locations was information they had found difficult to gather before. TMS worked with RWA to ensure the data being reported was completely accurate, and now they are using the tool to improve their workshop efficiency and productivity with confidence.

Technical Solution

The DMS data is collected through CDK extraction and an ODBC connection. The data is then manipulated, enriched with third party data sources, and augmented by RWA’s engineers. A suite of dashboards and reports for all departments are then developed to meet TMS’s requirements by RWA’s analysts.

Background

TMS Motor Group is an award-winning family owned and run business in Coventry, Hinckley and Leicester representing Volvo and Kia across sales and aftersales.

Benefits

• Much greater transparency and accountability across all levels.
• Ability to continuously focus on performances levels by Brand / Site/ Person.
• Realign management and staff roles based on much better information quality.
• Switching from collation effort to thinking time to take strategic actions.
• More consistent achievement against targets driving better results.