South Hereford Garages

South Hereford Garages2018-07-30T08:59:46+00:00

Project Description

South Hereford Garages

About the company

Established in 1973, South Hereford Garages in one of the UK’s leading Volkswagen retailers.

They are committed to continued success due to a consistent investment in people, training and equipment. Every department, from new and used car sales to service, parts and body repairs, is committed to ensuring their customers always receive the best possible service.

Their status as one of the few independent luxury car retailers enables them to offer customers an exclusive portfolio of additional services tailored to meet their individual requirements.

Challenges

  • The Finance Director’s used to prepare their monthly management reports and budgets, but the structure of their spreadsheet’s, which needed to accommodate the needs of conventional accounts, had no reporting, model and departmental analysis.   Completing the manufacturer’s composite reporting was always challenging and involved a lot of spreadsheet linking and often rekeying of data to deliver both levels from the same data.
  • At South Hereford data was loaded from their Kalamazoo DMS into a TB and then via various data mappings, a set of Management Reports is produced. Their main need was to be able to integrate the budget and the actual numbers so that they could slice and dice the data and they needed to produce a consolidated P&L across departments as well as combining their two dealerships which are spread across several locations. They also produce a weekly sales forecast which was “a pain” to maintain.

The Result

  • Jedox is a multi-dimensional database which allows the modelling of the business in “cube” structures. A separate cube was set up for each department so that it is easy for South Hereford to maintain the account structures at this level. Data is downloaded from Kalamazoo and each department’s cube is automatically updated from its own section of the P&L, which is then automatically aggregated in a consolidated P&L cube.
  • Weekly forecasts are now done in spreadsheets and the results uploaded into Jedox to produce the reports. The template approach reduces the number of spreadsheets that need to be managed. Every cost centre of the business can be viewed using a single template

Project Details

SOLUTION

Jedox

PRODUCT

Jedox Premium

APPLICATIONS

Budgeting, Forecasting and Reporting

INDUSTRY

Automotive

“We’re very pleased with the Jedox product and will have no hesitation in recommending it”

Ian Phillips
Financial Director

Related Clients

Let's Talk

NAME *
COMPANY *
EMAIL ADDRESS *
PHONE NUMBER

SUBJECT *

HOW CAN WE HELP? *

[wpgdprc "By using this form you agree with the storage and handling of your data by CFMS, so that we can respond to your inquiry."]

Register Here

Jedox Roadshow 2018 London
One Platform. Unlimited Possibilities.

21st June 2018 / London Hilton Paddington
Come and join us!
close-link