Making Severance and Notice Pay Calculation

An Excel file that teaches how to perform Making Severance and Notice Pay Calculation operation.

Excel Spreadsheet for Making Severance and Notice Pay Calculation

Service duration and fee parameters are entered into the table. Legal rates are read from a separate table. Seniority and notice amounts are calculated using a formula. Exceptions are explained in the notes section. The summary report shows the results item by item.

Hope it is useful.