Loading documents preview...
[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
5
5
5
5
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
9
9
9
9
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
9
9
9
9
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
8
8
8
8
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 Information Technology Sales Operations Marketing Corporate Totals
238
Total number of employees 20 36 40 42
Department Management Finance Human Resources Information Technology 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