Personnel assumptions

In the assumptions you can select whether you wish to include overtime. Enter the pay rate in % for weekdays and weekends, and select in which month bonuses are expected to be paid. If you enter any bonuses in the details they will be paid out in the month selected here. You can also select to add a payroll burden for bonuses paid, and enter the bonus payroll burden % separately if necessary in your country.

Payroll burden

This is optional though highly relevant in some countries. Try to enter the averages most appropriate for your country and ensure you are familiar with related local laws regarding this issue.

Personnel details

This worksheet is for adding, editing, or removing departments, persons, or groups. To add, edit or remove departments, groups or persons, press the MANAGE PERSONNEL button.

For each group (name cell in gray/green color) or person (name cell in white color) which is added, you need to enter:

1. the initial number of staff (applicable to groups only).
2. the starting date (optional). The date when the person is (expected to be) hired. If left blank, the starting date will be the starting date of the plan as entered in the Assumptions.
3. ending date (optional); the date of dismissal if it occurs within the 5 year plan.
4. the gross hourly rate.
5. the number of hours per month.
6. if overtime is selected, the number of hours at the weekdays and weekend rate per month.
7. if bonuses are applicable, the gross amount without payroll burden.

Production departments: If you select 'Yes' for Manufacturer in the Assumptions worksheet, you need to select whether a department is a production department or not. Select 'Yes' to ensure a department's cost is properly accounted for as Cost of Goods Sold. In addition, you will always need at least one production department.

Personnel planning

The financial workbook includes a summary personnel projection by department for 3 years (monthly and quarterly) and 5 years.

Personnel planning (5 years)