Merit Increase Budget Modeling Workbook

Size a merit pool and spend it. Eligible payroll rolls up from your register, your pool percentage turns it into dollars, and your own allocation matrix — performance rating against position in range — turns that into a per-employee increase you can defend line by line. The matrix and the pool percentage ship EMPTY: those are the two numbers a compensation product is most tempted to invent, and an Example tab runs the identical formulas so you can see the mechanism without being handed a norm.