Excel Dashboard for Hospital Bed Management
Thursday, September 13th, 2007Dashboard Topic: Demo of an Excel Dashboard for Hospital Bed Management.
Strategic management of hospital beds has become a high-pressure requirement in today’s world of health care facilities needing to do more with less resources. Like it or not, hospitals make money by determining the “right” kind of patients, procedures and getting the occupany and turn-over rates right. Yes, it seems cold-hearted, but strategic management of resources such as beds is what drives the profitability of health-care facilities.
Now, in defense of hospitals, I recently had the experience of bringing someone with an arm injury to the emergency room. This person was concerned because of her lack of health insurance. While checking in, however, the nurse and the admissions clerk both, in separate conversations, reassured us that they do not turn away people who need care. In fact they pointed out a sign posted in a prominent location that they do not turn away people because of an inability to pay.
Now, back to excel dashboards. Today we have the opportunity not only to look at screenshots of an excel dashboard for the management of hospital bed metrics, but, thanks to qimacros.com, you can actually download a working Excel worksheet for use as a hospital bed management dashboard system. Here is a screengrab of the goals and objectives of their bed dashboard system. I screen captured this page from their bed management demo video:








