Back

Intensive Care Unit Capital Budgeting Workbench: An Open Source Decision Support Application for High Acuity Investment Planning

Alwakeel, M.

2025-08-06 health systems and quality improvement
10.1101/2025.08.04.25332977 medRxiv
Show abstract

ObjectiveCapital budgeting in intensive care units (ICUs) demands rapid, high-stakes investment decisions. We developed an open-source ICU Capital Budgeting Workbench that merges a deterministic finance engine with GPT-based natural-language processing (NLP) to streamline planning. Materials and MethodsThe web application couples classic valuation metrics (e.g., net present value, internal rate of return, and payback) with an NLP module that converts multi-year free-text scenarios into structured projections. Users describe projects in everyday language; GPT parses these narratives into year-by-year cash flows and discount rates, after which the engine computes financial metrics and produces interactive sensitivity, scenario, and Monte Carlo analyses. ResultsIn illustrative cases the workbench translated narrative ICU expansion proposals into five and ten-year cash-flow tables and NPV calculations within seconds, eliminating manual spreadsheet construction. Interactive dashboards let users test key assumptions, instantly revealing how occupancy, reimbursement, or inflation shifts influence returns. Compared with traditional ad-hoc spreadsheets, the tool demonstrated marked time savings and consistent analytic structure. DiscussionThis proof-of-concept shows how large language models can reduce transcription errors, standardize methodology, and embed uncertainty modeling in routine capital planning. Limitations include dependence on GPTs parsing accuracy and the need for real-world validation with authentic hospital data. ConclusionThe ICU Capital Budgeting Workbench exemplifies practical AI integration for finance and operations leaders, offering transparent, reproducible, and scalable decision support for ICU equipment and facility investments. By replacing bespoke spreadsheets with a governed, open-source platform, it may improve efficiency and support better-informed, data-driven investment strategy.

Matching journals

The top 7 journals account for 50% of the predicted probability mass.

1
Medical Decision Making
12 papers in training set
Top 0.1%
12.9%
2
PLOS ONE
5266 papers in training set
Top 18%
9.9%
3
BMC Medical Informatics and Decision Making
43 papers in training set
Top 0.2%
9.1%
4
Journal of the American Medical Informatics Association
71 papers in training set
Top 0.6%
5.6%
5
PLOS Digital Health
106 papers in training set
Top 1%
4.9%
6
BMC Health Services Research
51 papers in training set
Top 0.5%
4.4%
7
Frontiers in Digital Health
24 papers in training set
Top 0.3%
3.5%
50% of probability mass above
8
Frontiers in Bioengineering and Biotechnology
98 papers in training set
Top 0.6%
2.7%
9
PLOS Global Public Health
344 papers in training set
Top 4%
2.7%
10
BMJ Open Quality
17 papers in training set
Top 0.3%
2.2%
11
Nature Communications
5641 papers in training set
Top 43%
1.9%
12
Scientific Reports
3612 papers in training set
Top 53%
1.8%
13
Health Policy
11 papers in training set
Top 0.3%
1.8%
14
BMJ Health & Care Informatics
15 papers in training set
Top 0.6%
1.5%
15
npj Digital Medicine
118 papers in training set
Top 2%
1.5%
16
Royal Society Open Science
214 papers in training set
Top 4%
1.4%
17
Journal of Clinical Pathology
15 papers in training set
Top 0.3%
1.1%
18
JMIR Medical Informatics
18 papers in training set
Top 0.6%
1.1%
19
Journal of Biomedical Informatics
47 papers in training set
Top 0.9%
1.1%
20
BMC Medical Research Methodology
47 papers in training set
Top 0.9%
1.1%
21
Frontiers in Public Health
148 papers in training set
Top 5%
1.1%
22
GigaScience
212 papers in training set
Top 3%
1.1%
23
BMJ Open
601 papers in training set
Top 11%
1.1%
24
Disaster Medicine and Public Health Preparedness
16 papers in training set
Top 0.6%
1.1%
25
BMJ Global Health
113 papers in training set
Top 3%
1.1%
26
Healthcare
17 papers in training set
Top 0.7%
1.1%
27
Frontiers in Artificial Intelligence
20 papers in training set
Top 0.6%
1.1%
28
Computational and Structural Biotechnology Journal
242 papers in training set
Top 5%
1.1%
29
JAMA Network Open
130 papers in training set
Top 3%
1.0%
30
Journal of Theoretical Biology
162 papers in training set
Top 2%
0.9%