Model Build: adding value to your business
With over 400 models built to date, we have experience of a vast variety of model structures, conventions and calculations to call upon. So, while your model may be unique, we are rarely starting from scratch.
How can we help?
Approach
We advocate spending a significant proportion of time on scoping, planning and designing — ensuring that the model delivers as much utility and usability as possible.
Our adaptive and personalised approach means our clients feel in control of model development at every stage of the process and ensures the final product is truly fit for purpose.
Examples
- a dealership scorecard model for a major European car manufacturer
- a tool to enable our client to understand and bid for large medical equipment contracts
- a tool to analyse and report questionnaire responses for a major UK university
- a model to prioritise alterations to a portfolio of wind turbines based on quantitative and qualitative factors
- a model to analyse historic healthcare costs to support an NHS Sustainability and Transformation Plan
Our clients
Case Studies
Virgin Trains is a train operating company that has operated the InterCity West Coast franchise since 1997. It operates long-distance passenger services on the West Coast Main Line between London, West Midlands, North West England, North Wales and Scotland.
The company’s previous process for budgeting, reporting actuals and updating forecasts was complex and time-consuming, with the complexity leading to errors in the final output. Over 80 spreadsheets were in use across 11 departments for the budget process alone. Duplication of common inputs led to inconsistency.
The company’s previous process for budgeting, reporting actuals and updating forecasts was complex and time-consuming, with the complexity leading to errors in the final output. Over 80 spreadsheets were in use across 11 departments for the budget process alone. Duplication of common inputs led to inconsistency.
Virgin Trains is a train operating company that has operated the InterCity West Coast franchise since 1997. It operates long-distance passenger services on the West Coast Main Line between London, West Midlands, North West England, North Wales and Scotland.
The company’s previous process for budgeting, reporting actuals and updating forecasts was complex and time-consuming, with the complexity leading to errors in the final output. Over 80 spreadsheets were in use across 11 departments for the budget process alone. Duplication of common inputs led to inconsistency.
F1F9 created a new process for updating, analysing and communicating large financial datasets in 8 Excel financial models which take inputs from core non-Excel management information systems. This dramatically increased budgeting and forecasting efficiency as well as reducing the risk of errors. The reporting process is now simple and more accurate with a rapid turnaround. We worked in close collaboration with our Virgin Trains contacts and completed the work in 2 months. The new process has been fully adopted within Virgin Trains and F1F9 are providing ongoing support.
The company’s previous process for budgeting, reporting actuals and updating forecasts was complex and time-consuming, with the complexity leading to errors in the final output. Over 80 spreadsheets were in use across 11 departments for the budget process alone. Duplication of common inputs led to inconsistency.
F1F9 created a new process for updating, analysing and communicating large financial datasets in 8 Excel financial models which take inputs from core non-Excel management information systems. This dramatically increased budgeting and forecasting efficiency as well as reducing the risk of errors. The reporting process is now simple and more accurate with a rapid turnaround. We worked in close collaboration with our Virgin Trains contacts and completed the work in 2 months. The new process has been fully adopted within Virgin Trains and F1F9 are providing ongoing support.