Annual Nursing Workforce Budget Planning Workbook

The Annual Nursing Workforce Budget Planning Workbook turns unit census and units-of-service into a budgeted-FTE and labor-cost projection you can defend. Enter each unit's patient-day assumptions, your target hours-per-patient-day and RN/LPN/CNA skill mix, and your productive-vs-nonproductive hours basis; the workbook converts demand into required nursing hours, then into budgeted FTE at 2,080 paid hours each, then into a labor-cost projection using loaded rates you enter by role. It asserts no market wage, no benchmark HPPD and no industry FTE figure — every rate, ratio and target is your own number, and a blank input is treated as not-set rather than as zero, so a missing HPPD or rate never renders a false 0 FTE or $0 budget.