V Ships
Shipping & Logistics | United Kingdom
Owner: Advent International
PROJECT OVERVIEW
SCOPE
Identify short-comings of in-development customer profitability BI Dashboard suite
Examine existing MI reporting processes and outputs
Examine Shareholder Reporting Pack
Examine data interconnectedness across 70 locations
SOLUTIONS
Re-structure and re-implement at all reporting entities (x150) a new chart of accounts reflecting true commerciality of business units
Design, develop and implement new monthly MI / shareholder reporting pack
Design and implement automation of transactional data capture
Implement system controls to resolve data quality issues
Implement cost allocation logic in Dashboard to enable analysis of customer and vessel level profitability
Design and roll-out POWERBI reporting suite with full drill-down
MAJOR BENEFITS
Clarity in MI highlighted revenue trends that enabled sales team to re-focus efforts on promoting certain products and targeting vessel types
Customer profitability analysis highlighted white-space on sales of value-added services
FTE and Costs per location analysis made possible, allowing benchmarking and cost-out program to be focused
Month-end reporting processes were significantly simplified
FP&A – detailed analyses enabled by ensuring right level of detail captured at data entry points
Testimonial
“1Truth were engaged in conjunction with owners Advent International to help us construct a group-wide customer and product profitability analysis solution and dynamic reporting suite. In a complex reporting environment, they were able to construct a comprehensive and robust solution. We expect this this work to yield significant EBITDA improvement opportunities.”
Marcel Crince, Interim CFO, V SHIPS