Hospital Surge Capacity Model logo

Hospital Surge Capacity Model

by Northeastern University
VISIT OFFICIAL WEBSITE →

OVERVIEW

A free, Excel-based model developed by Northeastern University to estimate 1- to 30-day hospital demand for beds, ventilators, PPE, and staff during a surge event.

The Hospital Surge Capacity Model is a free, downloadable tool developed by Northeastern University, adapting prior research supported by the Agency for Healthcare Research and Quality (AHRQ), the National Science Foundation, and the National Institutes of Health.

Product Overview and Key Benefits This model was created to help health systems and policymakers estimate and visualize 1- to 30-day ahead hospital-specific demand for critical resources during a public health emergency, such as a COVID-like epidemic. Its overall objective is to provide early signaling of capacity, supplies, and staffing concerns at the hospital and system levels to inform critical operational decisions. It blends theoretic and data-driven modeling methods to produce detailed, actionable decision support, integrating factors like current patient census and local new case predictions.

Main Features and Capabilities

  • 1-30 Day Demand Forecasting: Estimates resource needs on a rolling basis.
  • Resource Demand Estimation: Projects demand for medical and ICU beds, ventilators, Personal Protective Equipment (PPE), medications, and available staff.
  • Scenario Modeling: Helps answer questions like the daily number of ICU patients and when to convert routine space to ICU or isolation beds.
  • Probabilistic Range: Provides the probabilistic range of results over the next week and month, accounting for inherent variability (e.g., random lengths-of-stay).
  • User-Friendly Format: The model is implemented in Microsoft Excel for ease of use and sharing.
  • Reporting: Results are displayed graphically as run charts over time and tabularly, formatted for printing to facilitate clinical team communications.

Target Users and Use Cases

  • Target Users: Hospital staff responsible for management, clinical teams, and policymakers.
  • Use Cases: Hospital surge planning, informing operational decisions, and expediting significant concerns regarding capacity and supplies during epidemics.

RATING & STATS

Customers
100+
Founded
2020

KEY FEATURES

  • 1-30 day demand forecasting
  • ICU and medical bed demand estimation
  • Ventilator and PPE consumption tracking
  • Staff availability modeling
  • Graphical and tabular results

PRICING

Model: free
The tool is freely available to any health system worldwide.
FREE TIER

TECHNICAL DETAILS

Deployment: on_premise
Platforms: windows, mac

USE CASES

Hospital surge planningOperational decision support during epidemicsResource allocation and managementCapacity management

SUPPORT & IMPLEMENTATION

Implementation Time: < 1 week
Target Company Size: medium, enterprise

PROS & CONS

✓ Pros:
  • +Free and easily accessible (Excel format)
  • +Focuses on granular, actionable 1-30 day forecasts
  • +Estimates multiple critical resources (beds, PPE, staff)
  • +Developed by academic experts with AHRQ-supported research foundation
✗ Cons:
  • -Requires manual data input
  • -Limited to the Microsoft Excel platform
  • -No official ongoing support or guaranteed updates
  • -Not formally evaluated or validated by AHRQ

TRY IT OUT

ABOUT NORTHEASTERN UNIVERSITY

RELATED SURGE CAPACITY PLANNING SOFTWARE

BROWSE SOFTWARE IN SURGE CAPACITY PLANNING

No previous software