Title

Using data analytics to manage bed capacity at LCX hospital

Publication Type

Case

Year Completed

2-2018

Abstract

The operational management of allocating beds to patients is a challenging task, and an important component of a hospital’s processes. Given the lean bed capacity that LCX hospital had experienced in the past few months, John Teo, the director of the Bed Management Unit (BMU), and Doe Claris, the second in lead, were tasked to set up a workgroup with relevant stakeholders to examine the current policies and strategies of BMU, and seek out new and innovative solutions to improve the process of bed allocation to in-patients. Teo and Claris hope to improve the bed management system using the predictive capabilities of data analytics and mathematical modelling tools.

Through this case, students are expected to derive a suitable model to determine a bed allocation policy. The case reinforces the students’ skills in data processing, mathematical modelling, and numerical computation. Concepts and techniques covered include spreadsheet modelling, Linear Programming (LP), Optimisation, and Post-optimality analysis (such as shadow prices, sensitivity report and resolving model).

Keyword(s)

Data Analytics, Mathematical Modelling, Spreadsheet Modelling, Linear Programming (LP), Optimisation, Post-Optimality Analysis, Hospital Bed Allocation

Discipline

Analytical, Diagnostic and Therapeutic Techniques and Equipment | Business Administration, Management, and Operations | Portfolio and Security Analysis

Research Areas

Operations Management

Data Source

Field Research

Industry

Health Care Equipment and Services

Geographic Coverage

Singapore

Temporal Coverage

2017

Education Level

Executive Education; Postgraduate; Undergraduate

Publisher

Singapore Management University

Case ID

SMU-17-0027

Comments

SMU Faculty/Staff can download the case and teaching note with your SMU login ID and Password via the following links:

The Case (SMU-17-0027)

For purchase of the case and supplementary materials via The Centre for Management Practice, please access the following link:

For purchase of the case and supplementary materials via The Case Centre, please access the following links:

Share

COinS