Financial forecast integration with resource management

Client Profile

The Venture Studio builds tech-driven businesses collaborating with passionate CoFounders on a journey from  idea to investment, MVP and beyond. Their business model involves providing team resource flexibly to their portfolio businesses, some of which is dependant on inward investment which means things can change quickly and accurate forecasting and reliable live data is a must.

Client
The Venture Studio
Industry
Venture Builder
Client's Goals

The Venture Studio aimed to expand its operations, increasing headcount and tapping into new markets to increase its customer base and revenue.

Challenges

1. Resource Complexity:
  • Analysing and forecasting resource demand factors across a portfolio of 40 different high growth businesses.
  • 14 different skill sets / job roles and consultants that require different billing rates.
  • Bespoke pricing and terms sheets for each business dependant on their customer lifecycle stage
  • Unknown and varying timescales to recruit the right team members to deliver customer projects
2. International Workforce and Customer Segments:
  • Devising strategies to reduce the impact of currency fluctuations.
  • Compliance to diverse international regulations and varying market forces.
  • Ensuring stable financial performance during global transactions.
3. Project Overrun and Over / Under Utilisation Risk:
  • Accurately aligning project start / end days with forecasted hires, training and onboarding
  • Mitigating risk around potential project delays and the impact on cashflow
  • Maintaining positive cost performance index and working policies during periods of sustained growth

Significant results

The collaborative efforts between Gain Insight and The Venture Studio have produced great results during their continued business expansion. In the realm of business model and market complexity - this was high. An in-depth analysis was conducted that highlighted the areas to prioritise (where we'd see the quickest wins, fastest) and we got our heads stuck into the resourcing complexities and how to accurately forecast utilisation and constantly feed the actuals data in to adjust the assumptions we were making. We were able to pull data from Google Sheets and Run.io and pull this into a bespoke dashboard using Causal and custom code (Python). This allowed the team to see risks of under utilisation and a greater visibility of hiring requirements and timings going forward.

We then focused on building models and strategies for currency risk mitigation associated with the international hires required, this led to a notable 7% reduction in margin impact and a stronger cash on hand position which was able to enable a strong and stable financial performance throughout the increased hiring period. As the team expanded their hiring regions we provided localised financial compliance support to ensure that all international regulations were adhered to.

The internal stakeholders were keen to press the importance of aligning the projects onboarding (and the money in) with the resource required to deliver that work. With each customer project having a bespoke set of requirements and timeframes, some of which were dependant on external suppliers and client actions, it was clear it was a challenge that had been causing a lot of headaches. We were able to simplify the process and add flexibility to the model that sits behind it to build in mitigation factors that allowed core team members to quickly and easily adjust the plans and share it with all key stakeholders in an easy to digest manner.

14%

Increase in annual revenue

80%+

Consistent Billable Utilisation

<4%

Cost Variance

7%

Trimmed costs

Realise the unseen insights within your business data.

Book a free discovery call for a no-strings, impartial chat about your current challenges around FP&A, Modelling and BI.

Speak to the Gain Insight team
15%
arrow
Revenue Growth
chart