Quattro Plant – Prophix project summary

Quattro Plant– Prophix project summary

Background of client business

Basic characteristics

Type / Details
Industry / Transportation and logistics
Operating since / 1989
Location – head office / Stratford, East London
Annual revenue / 2013 - £40 million
Number of employees / 2013 – 400+
ERP / Sage 200
Website /
Prophix champion / Nick Nkana, Senior Management Accountant –
Key contacts and relationship with Prophix / Nick Thomson, Finance Director –
Life cycle
☒ New implementation
Implementation date: March of 2014
☐ Preexisting customer
Original implementation date: ______
☐ Existing customer, upgrading
Original implementation date: ______

Revenue streams

  • The Quattro Group has expanded to become the second largest rail plant provider in the UK, the largest operator of environmental machines in the UK and one of the largest operated plant/municipal hire companies

Key expenses

  • Fuel costs and labour costs account for over 60% of total costs

Important facts

  • 13 depots across the UK
  • Have 4 divisions: Road, Rail, Transport and Civil

Business issues / pain points

  • One big Excel spreadsheet was being used to contain all of the budget. Due to the size of the spreadsheet it became almost unmanageable to continue budgeting in this manner
  • Quattro were trying to do weekly Revenue planning. The current method involved the 4 budget members connecting to one Excel file on a weekly basis to enter their weekly planning, however most weeks were not completed. Prophix would allow this process to be automated through a workflow

Prophix solution

Solution overview

Describe how our software was used to address the business issue and/or challenge and why it was selected.

Solutions built / Capabilities used
☒ Budgeting / ☒ Automation
☒ Forecasting / ☐ Prophix Mobile
☒ Reporting / ☒ Data integration
☒ Strategic planning / ☐ Business modeling
☐ Financial consolidation / ☐ Microsoft platform integration
☒ Analysis / ☐ Role-based security
☐ Profitability analysis / ☒ Collaboration
☐ Personnel planning / ☐ Flexible deployment
☐ Project planning / ☒ Ad hoc reporting and visualization
☒ Revenue planning
☐ Capital expenditures planning
☐ Reporting and analytics
(dashboards and scorecards)

Unique solutions

  • The model was designed with a summarized financial model that collected all P&L, balance sheet and cash flow data on a monthly basis from Sage 200, as well as summarized monthly data feeding from the weekly models. This cube would be used to produce the monthly management reports.
  • A separate weekly model was built for weekly revenue planning by customer, with calculations feeding off a 13 week historical average
  • A separate weekly model was also to be built to calculate direct costs, this time not by customer

Benefit realized

  • Currently we are only two thirds of the way through the implementation and it is not currently being fully used, as such there are no current benefits to the project.

Support materials

Figure 1

Industry (choose all that apply)
☐ Agriculture, forestry, and fishing / ☐ Professional services
☐ Financial services / ☐ Retail
☐ Wholesale and distribution / ☐ Telecommunications
☐ Healthcare / ☐ Utilities
☐ Education / ☐ Architecture, engineering, and construction
☐ Life science / ☐ Transportation and logistics
☐ Manufacturing / ☐ High tech
☐ Media and entertainment / ☐ Government
☐ Non-profit

1