Overtime & Understaffing Premium Cost Model

Turn your unit overtime hours, incremental agency shifts and shift differentials into a single monthly and annualized cost of understaffing — then set it beside the loaded cost of the budgeted FTE it stands in for. You enter OT hours and premium multipliers by unit, capture premium agency shifts separately from base staffing, and layer in night, weekend and holiday differentials; the workbook rolls them into one premium-burn figure and ranks your units by it. Every rate, hour and loaded-cost figure is yours — the model asserts no wage, no agency rate and no industry premium, and computes only on the numbers you type.