The purpose of this worksheet is to help you project future salaries. The first three columns show the actual data for each department, including number of employees in each position, actual average salary, and total salaries. The second group of columns displays planned information for each position including actual number of employees in each position, planned midpoint, and current budget for the position. The current budget is calculated from the number of employees in the position times the planned midpoint.

The last group of columns is a worksheet for you to complete. It is similar to the previous two columns. You can also add additional Positions and projected data in this worksheet.

Figure 11 Salary Planning Worksheet