A forecasting tool for a hospital to plan inbound transfers of COVID-19 patients from other regions

Abstract

Abstract Background In April 2021, the province of Ontario, Canada, was at the peak of its third wave of the COVID-19 pandemic. Intensive Care Unit (ICU) capacity in the Toronto metropolitan area was insufficient to handle local COVID patients. As a result, some patients from the Toronto metropolitan area were transferred to other regions. Methods A spreadsheet-based Monte Carlo simulation tool was built to help a large tertiary hospital plan and make informed decisions about the number of transfer patients it could accept from other hospitals. The model was implemented in Microsoft Excel to enable it to be widely distributed and easily used. The model estimates the probability that each ward will be overcapacity and percentiles of utilization daily for a one-week planning horizon. Results The model was used from May 2021 to February 2022 to support decisions about the ability to accept transfers from other hospitals. The model was also used to ensure adequate inpatient bed capacity and human resources in response to various COVID-related scenarios, such as changes in hospital admission rates, managing the impact of intra-hospital outbreaks and balancing the COVID response with planned hospital activity. Conclusions Coordination between hospitals was necessary due to the high stress on the health care system. A simple planning tool can help to understand the impact of patient transfers on capacity utilization and improve the confidence of hospital leaders when making transfer decisions. The model was also helpful in investigating other operational scenarios and may be helpful when preparing for future outbreaks or public health emergencies.

Keywords

• COVID-19
• Simulation
• Spreadsheet
• Capacity planning
• Emergency response