VIEWS: 2 PAGES: 3 POSTED ON: 12/13/2011
NEXT WEEK'S SCHEDULE ON FRIDAY DEMAND MON TUES WED THURS FRI Surgical Admissions ICU Telemetry Med/Surg Unit Non-surgical Admissions ICU Telemetry Med/Surg Unit Cardiac Procedure Admissions ICU Telemetry Med/Surg Unit Predicted Admissions from the ED ICU Telemetry Med/Surg Unit Predicted Direct Admits ICU Telemetry Med/Surg Unit Average Midnight Census ICU 0 0 0 0 Telemetry 0 0 0 0 Med/Surg Unit 0 0 0 0 TOTAL DEMAND Hospital 0 0 0 0 0 ICU 0 0 0 0 0 Telemetry 0 0 0 0 0 Med/Surg Unit 0 0 0 0 0 CAPACITY Staffed Beds ICU Telemetry Med/Surg Unit TOTAL **PREDICTED OCCUPANCY RATES** MON TUES WED THURS FRI Hospital #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! ICU #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Telemetry #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! M/S Unit #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 1. Complete this worksheet on Friday for the next week. 2. Use next week's actual surgical, non-surgical, and cardiac procedure schedules to predict ICU, Telemetry, and M/S unit admissions. 2. Use historical data on ED admissions and direct admits to predict admissions from the ED and direct admissions. 3. Use the predicted Sunday midnight census for Monday. The prediction should be based on historical data and the current situation on Friday. This is the only midnight census you need to input. Factors are entered in the spreadsheet to predict the midnight census for Tuesday through Friday. In the spreadsheed for ICU, Telemetry, and the M/S units, the midnight census for Tuesday will be 5% higher than Monday and Wednesday will be 5% higher than Tuesday. Thursday and Friday will be the same as Tuesday. If you need to change the factors for your hospital, click on the appropriate cell and make the change in the formula at the top of the spreadsheet. 4. Total Demand will be calculated automatically. 5. Under Capacity, enter your approximate staffed beds for the next week. This will most likely be the same number for Monday through Friday. 6. The predicted daily occupancy rates for Monday through Friday will be shown on the Data Summary worksheet. These occupancy rates do not include internal transfers or discharges. Use these predictions to plan patient placement to better match capacity with demand.
Pages to are hidden for
"week-ahead-template"Please download to view full document