Headcount and Payroll Planning Model

[Company Name & Logo]<--Insert user's company name & logo
Headcount and Payroll Planning Model

[Prepare by: (Name & position]<--insert name & porsition
[Year]<--Insert year of entry
Insert positions and the quarters into the white areas. The grey areas show calculated totals, costs, and annual costs.
HEADCOUNT SUMMARY
Management
Chief executive officer
Chief financial officer
Chief operating officer
Chief information officer
President
Total
Finance
Vice president
Financial controll
Financial manager
Accountant
Account executive
Accounts receivable
Accounts payable
Treasury
Total
Human Resources
Vice president
Director
Human resource manager
Benefits coordinator
Compensation manager
Human resource generalist
Payroll assistant
Trainer
Recruiter
Total
Information Technology
Vice president
Director
Systems engineer
Systems analyst
Technician
Support
Architect
Programmer
Total
Sales
Vice president
Regional director
Business development
Direct sales representative
Inside sales
Sales operations
Channel sales representative
Total
Operations
Vice president
Director
Q1
Q2
Q3
Annual
total
Q4
Annual
salary
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
4
4
4
4
4
20
1
1
2
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
2
1
1
1
1
1
4
4
8
4
4
4
4
4
36
1
1
2
1
2
2
1
1
1
2
1
2
2
1
1
1
2
1
2
2
1
1
1
2
1
2
2
1
4
4
8
4
8
8
4
0
0
10
10
10
10
40
1
1
2
1
1
2
1
1
1
1
2
1
1
2
1
1
1
1
2
1
2
2
1
1
1
1
2
1
2
2
1
1
4
4
8
4
6
8
4
4
10
10
11
11
42
1
2
1
4
1
1
1
1
2
1
4
1
1
1
1
2
1
4
1
1
1
1
2
1
4
1
1
1
4
8
4
16
4
4
4
11
11
11
11
44
1
1
1
1
1
1
1
1
4
4
Q1 cost
Q2 cost
Q3 cost
Q4 cost
Annual cost
$300,000
250,000
225,000
225,000
240,000
$75,000
62,500
56,250
56,250
60,000
0
$310,000
$75,000
62,500
56,250
56,250
60,000
0
$310,000
$75,000
62,500
56,250
56,250
60,000
0
$310,000
$75,000
62,500
56,250
56,250
60,000
0
$310,000
$300,000
250,000
225,000
225,000
240,000
0
$1,240,000
$200,000
125,000
100,000
70,000
85,000
85,001
85,002
85,003
$50,000
31,250
50,000
17,500
21,250
21,250
21,251
21,251
0
$233,752
$50,000
31,250
50,000
17,500
21,250
21,250
21,251
21,251
0
$233,752
$50,000
31,250
50,000
17,500
21,250
21,250
21,251
21,251
0
$233,752
$50,000
31,250
50,000
17,500
21,250
21,250
21,251
21,251
0
$233,752
$200,000
125,000
200,000
70,000
85,000
85,001
85,002
85,003
0
$935,006
$140,000
100,000
80,000
75,000
75,000
65,000
65,000
65,000
65,000
$35,000
25,000
40,000
18,750
37,500
32,500
16,250
0
0
0
$205,000
$35,000
25,000
40,000
18,750
37,500
37,500
16,250
0
0
0
$210,000
$35,000
25,000
40,000
18,750
37,500
37,500
16,250
0
0
0
$210,000
$35,000
25,000
40,000
18,750
37,500
37,500
16,250
0
0
0
$210,000
$140,000
100,000
160,000
75,000
150,000
145,000
65,000
0
0
0
$835,000
$140,000
110,000
90,000
90,000
80,000
75,000
80,000
80,000
$35,000
27,500
45,000
22,500
20,000
37,500
20,000
20,000
0
$227,500
$35,000
27,500
45,000
22,500
20,000
37,500
20,000
20,000
0
$227,500
$35,000
27,500
45,000
22,500
40,000
37,500
20,000
20,000
0
$247,500
$35,000
27,500
45,000
22,500
40,000
37,500
20,000
20,000
0
$247,500
$140,000
110,000
180,000
90,000
120,000
150,000
80,000
80,000
0
$950,000
$120,000
100,000
90,000
90,000
75,000
75,000
80,000
$30,000
50,000
22,500
90,000
18,750
18,750
20,000
0
$250,000
$30,000
50,000
22,500
90,000
18,750
18,750
20,000
0
$250,000
$30,000
50,000
22,500
90,000
18,750
18,750
20,000
0
$250,000
$30,000
50,000
22,500
90,000
18,750
18,750
20,000
0
$250,000
$120,000
200,000
90,000
360,000
75,000
75,000
80,000
0
$1,000,000
$150,000
100,000
$37,500
25,000
$37,500
25,000
$37,500
25,000
$37,500
25,000
$150,000
100,000
Manager
Floor manager
Assistant
1
5
1
1
5
1
1
5
1
1
5
1
4
20
4
Total
36
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
4
4
4
4
4
4
4
4
62
62
63
Marketing
Vice president
Director
Product manager
Market research
Market analyst
Product manager
Merchandiser
Assistant
Total
Corporate totals
85,000
65,000
45,000
21,250
81,250
11,250
0
$176,250
21,250
81,250
11,250
0
$176,250
21,250
81,250
11,250
0
$176,250
21,250
81,250
11,250
0
$176,250
85,000
325,000
45,000
0
$705,000
$135,000
105,000
90,000
75,000
75,000
90,000
70,000
50,000
20
$33,750
26,250
22,500
18,750
18,750
22,500
17,500
12,500
0
$172,500
$33,750
26,250
22,500
18,750
18,750
22,500
17,500
12,500
0
$172,500
$33,750
26,250
22,500
18,750
18,750
22,500
17,500
12,500
0
$172,500
$33,750
26,250
22,500
18,750
18,750
22,500
17,500
12,500
0
$172,500
$135,000
105,000
90,000
75,000
75,000
90,000
70,000
50,000
0
$690,000
63
238
$1,575,002
$1,580,002
$1,600,002
$1,600,002
$6,355,006
$1,240,000
935,006
835,000
950,000
1,000,000
705,000
690,000
$310,000
233,752
208,750
237,500
250,000
176,250
172,500
Salary +
benefits
$1,550,000
1,168,758
1,043,750
1,187,500
1,250,000
881,250
862,500
$6,355,006
$1,588,752
$7,943,758
KEY MODEL INPUTS

Fringe benefit percentage
Fiscal revenue
25.0% <-- Insert benefit percentage as deemed fit

$5,256,000 <-- Insert fiscal revenue as deemed fit
SUMMARY DATA BY DEPARTMENT

Total number
of employees
20
36
40
42
44
36
20
Department
Management
Finance
Human Resources
Sales
Operations
Marketing
Corporate Totals
238
Total number
of employees
20
36
40
42
Department
Management
Finance
Human Resources
Sales
Operations
Marketing
44
36
20
238
Total salary
% of total
Benefits
Total comp
% of total
8.4%
15.1%
16.8%
17.6%
18.5%
15.1%
8.4%
$1,936,000
1,312,258
1,085,500
1,235,000
1,650,000
951,750
897,000
21.4%
14.5%
12.0%
13.6%
18.2%
10.5%
9.9%
100.0%
$9,067,508
100.0%
Variable
compensation %
15.0%
10.0%
5.0%
5.0%
40.0%
10.0%
5.0%
Variable
pay
$186,000
93,500.60
41,750.00
47,500.00
400,000.00
70,500.00
34,500.00
Stock-based
compensation
$873,751
Total compensation
$200,000
50,000.00
0.00
0.00
0.00
0.00
0.00
$1,936,000
1,312,258.10
1,085,500.00
1,235,000.00
1,650,000.00
951,750.00
897,000.00
$250,000
$9,067,508
Key metrics:
Revenue/employee
Total compensation/employee
$22,084
$38,099
Quarterly metrics:
Salary
Q1
Q2
Q3
Q4
$1,575,002
1,580,002
1,600,002
1,600,002
$6,355,006
Benefits
$393,750
395,000
400,000
400,000
$1,588,752
Salary + benefits
$1,968,752
1,975,002
2,000,002
2,000,002
$7,943,758
Quarterly Analysis of Salary and Benefits

$2,500,000
$2,000,000
$1,500,000
Salary
$1,000,000
$500,000
$0
Q1
Q2
Quarter
Q3
Q4
Benefits
Salary + benefits

Headcount and Payroll Planning Model

Uploaded by

Copyright:

Available Formats

Headcount and Payroll Planning Model

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Headcount and Payroll Planning Model

Uploaded by

Copyright:

Available Formats

[Company Name & Logo]<--Insert user's company name & logo

Headcount and Payroll Planning Model

KEY MODEL INPUTS

25.0% <-- Insert benefit percentage as deemed fit

SUMMARY DATA BY DEPARTMENT

Quarterly Analysis of Salary and Benefits

You might also like