Demand forecast for hospitals

data

Objective

A healthcare client needed to predict demand over 8 years and simulate the impact of a variety of initiatives.

Key challenges:

  • Consolidating complex data from several different sources
  • Forecasting demand at the most granular level, based on a multitude of factors
  • Simulating the impact of different initiatives for individual sites and Primary Care Trusts at different granularities (including closing and opening of hospital specialties/departments)
2

Technical solution

Access database with Excel front-end.

Access database contains:

  • Data from multiple sources (e.g. estimated demographic development per zip code)
  • Simulation logic and results

Excel front-end:

  • Modify simulation parameters and trigger simulation
  • Create reports based on simulation results
  • Export results to PowerPoint and standard Excel format required by authorities
impact

Result

The client managed to prepare a detailed forecast and initiative plan for the next decade based on the simulation tool. Results were reported to authorities in time without the usual need for readjustment afterwards.

Industry
Healthcare & Pharma
Tool type
Forecasting
Project duration
3 months
d2i effort
60 MD
Data volume
Tools involved
Excel
PowerPoint
Access