Transcription of * How to Use the Staffing Hours Budget Worksheet
1 12/30/15 7:03 AM Page 17. * How to Use the Staffing Hours Budget Worksheet 1. Set minimum Staffing levels Minimums Mon Tues Wed Thurs Fri Estimate the minimum number of staffers by day for pre- and post-op areas and the ORs Pre-/post-op 6 6 6 6 4. for each day of the week. This is the number of staff needed to meet regulatory and Surgery 8 9 8 8 6. operational requirements (excluding administrative staff). The days would be tight and everyone would be working tirelessly, but you could make it work. Enter these minimum estimates in the appropriate boxes on the Worksheet . Maximums Mon Tues Wed Thurs Fri 2. Set maximum Staffing levels Pre-/post-op 9 9 9 9 5 Now estimate the maximum number of staffers the amount that would let your team Surgery 13 14 15 13 7 work at a comfortable pace with regular breaks, but without too much standing around. Think of scenarios where you have all the staff you need and everyone is present not sick or on vacation and you can easily meet regulatory and operational requirements.
2 Enter these maximum estimates for each day of the week in the appropriate boxes on the Worksheet . 3. How many Tuesdays in the month? Consult a calendar to figure out how many days of the week (Mondays, Tuesdays, Wednesdays and so on) there are in each month. Don't include holidays. Enter the numbers in the appropriate columns. The Worksheet will then automatically multiply the number of staffers needed per day by the number of days in each month to calculate monthly minimum and maximum Staffing levels for pre- and post- op areas and the OR. Pre-/Post-op Surgery Estimated Staffing Staffing Staffing Levels Levels Hours FY 2015 Mon Tues Wed Thurs Fri Min Max Min Max Min Max Actual Hourly Totals 5. Overstaffed or understaffed? July 5 5 3 4 4 118 173 165 260 2830 4330 3593 As the year progresses, enter the August 4 4 5 5 5 128 187 178 283 3060 4700 3630 actual monthly Staffing Hours in the September 3 4 4 4 4 106 155 148 235 2540 3900 3353 column on the far right of this portion October 5 5 5 4 4 130 191 181 290 3110 4810 4192 of the spreadsheet.
3 This is your bud- November 4 4 4 4 4 112 164 156 248 2680 4120 3299 get-to-actual Staffing Hours report. Do they fall within the budgeted December 3 3 4 4 4 100 146 139 221 2390 3670 2725. range? If your actual Staffing Hours January 4 4 5 5 4 124 182 172 276 2960 4580 4261 consistently fall below the estimated February 4 4 4 4 4 112 164 156 248 2680 4120 3593 range, you might need to add addi- March 4 4 4 4 5 116 169 162 255 2780 4240 3593 tional staff. If the actual Hours are April 5 5 4 4 4 124 182 173 275 2970 4570 3889 often beyond the estimated range, May 3 4 5 5 5 122 178 170 270 2920 4480 4431 you might need to streamline your June 4 4 4 4 4 112 164 156 248 2680 4120 3700 staff or schedule more efficiently. Total 33600 51640 44259. 4. Calculate monthly Staffing Hours The Worksheet will calculate monthly minimum and maximum Staffing Hours . It will automatically * Download your Worksheet at multiply your monthly Staffing levels by the number of Hours in your standard workday to calculate minimum and maximum Staffing Hours for each month.
4 J A N U A R Y 2 0 1 6 O U T PAT I E N T S U R G E R Y . N E T 1 7.
