[Company Name] Headcount and Payroll Planning [Year]
HEADCOUNT SUMMARY
Executive Chief executive officer Chief financial officer Chief operating officer Chief information officer President Total Finance Vice president Financial planning director Financial analyst Credit analyst Advisor Total Human Resources Vice president Director Senior human resource representative Benefits coordinator Compensation manager Human resource generalist Payroll Trainer Recruiter Total Information Technology Vice president Director Systems engineer Systems analyst Technician Support Architect Programmer Total Accounting Vice president Controller Accounting manager Accounts receivable Accounts payable Treasury General accountant Total Sales Vice president Regional director Business development
Q1
1.00 1.00 1.00 1.00 1.00 5.00
Q2
1.00 1.00 1.00 1.00 1.00 5.00
Q3
1.00 1.00 1.00 1.00 1.00 5.00
Q4
1.00 1.00 1.00 1.00 1.00 5.00
Annual total
4.00 4.00 4.00 4.00 4.00 0.00 20.00
Annual salary
$300,000 250,000 225,000 225,000 240,000
Q1 cost
$75,000 62,500 56,250 56,250 60,000 0 $310,000
Q2 cost
$75,000 62,500 56,250 56,250 60,000 0 $310,000
Q3 cost
$75,000 62,500 56,250 56,250 60,000 0 $310,000
Q4 cost
$75,000 62,500 56,250 56,250 60,000 0 $310,000
Annual cost
$300,000 250,000 225,000 225,000 240,000 0 $1,240,000
1.00 1.00 2.00 1.00 1.00 6.00
1.00 1.00 2.00 1.00 1.00 6.00
1.00 1.00 2.00 1.00 1.00 6.00
1.00 1.00 2.00 1.00 1.00 6.00
4.00 4.00 8.00 4.00 4.00 0.00 24.00
$200,000 125,000 100,000 70,000 85,000
$50,000 31,250 50,000 17,500 21,250 0 $170,000
$50,000 31,250 50,000 17,500 21,250 0 $170,000
$50,000 31,250 50,000 17,500 21,250 0 $170,000
$50,000 31,250 50,000 17,500 21,250 0 $170,000
$200,000 125,000 200,000 70,000 85,000 0 $680,000
1.00 1.00 2.00 1.00 2.00 2.00 1.00
1.00 1.00 2.00 1.00 2.00 2.00 1.00
1.00 1.00 2.00 1.00 2.00 2.00 1.00
1.00 1.00 2.00 1.00 2.00 2.00 1.00
10.00
10.00
10.00
10.00
4.00 4.00 8.00 4.00 8.00 8.00 4.00 0.00 0.00 0.00 40.00
$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
1.00 1.00 2.00 1.00 1.00 2.00 1.00 1.00 10.00
1.00 1.00 2.00 1.00 1.00 2.00 1.00 1.00 10.00
1.00 1.00 2.00 1.00 2.00 2.00 1.00 1.00 11.00
1.00 1.00 2.00 1.00 2.00 2.00 1.00 1.00 11.00
4.00 4.00 8.00 4.00 6.00 8.00 4.00 4.00 0.00 42.00
$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
1.00 1.00 1.00 1.00 1.00 1.00 1.00 7.00
1.00 1.00 1.00 1.00 1.00 1.00 1.00 7.00
1.00 1.00 1.00 1.00 1.00 1.00 1.00 7.00
1.00 1.00 1.00 1.00 1.00 1.00 1.00 7.00
4.00 4.00 4.00 4.00 4.00 4.00 4.00 0.00 28.00
$130,000 95,000 75,000 55,000 55,000 75,000 55,000
$32,500 23,750 18,750 13,750 13,750 18,750 13,750 0 $135,000
$32,500 23,750 18,750 13,750 13,750 18,750 13,750 0 $135,000
$32,500 23,750 18,750 13,750 13,750 18,750 13,750 0 $135,000
$32,500 23,750 18,750 13,750 13,750 18,750 13,750 0 $135,000
$130,000 95,000 75,000 55,000 55,000 75,000 55,000 0 $540,000
1.00 2.00 1.00
1.00 2.00 1.00
1.00 2.00 1.00
1.00 2.00 1.00
4.00 8.00 4.00
$120,000 100,000 90,000
$30,000 50,000 22,500
$30,000 50,000 22,500
$30,000 50,000 22,500
$30,000 50,000 22,500
$120,000 200,000 90,000
Direct sales representative Inside sales Sales operations Channel sales representative Total Operations Vice president Director Manager Floor manager Assistant Total Marketing Vice president Director Product manager Market research Market analyst Product manager Merchandiser Assistant Total Corporate totals
4.00 1.00 1.00 1.00 11.00
4.00 1.00 1.00 1.00 11.00
4.00 1.00 1.00 1.00 11.00
4.00 1.00 1.00 1.00 11.00
16.00 4.00 4.00 4.00 0.00 44.00
90,000 75,000 75,000 80,000
90,000 18,750 18,750 20,000 0 $250,000
90,000 18,750 18,750 20,000 0 $250,000
90,000 18,750 18,750 20,000 0 $250,000
90,000 18,750 18,750 20,000 0 $250,000
360,000 75,000 75,000 80,000 0 $1,000,000
1.00 1.00 1.00 5.00 1.00 9.00
1.00 1.00 1.00 5.00 1.00 9.00
1.00 1.00 1.00 5.00 1.00 9.00
1.00 1.00 1.00 5.00 1.00 9.00
4.00 4.00 4.00 20.00 4.00 0.00 36.00
$150,000 100,000 85,000 65,000 45,000
$37,500 25,000 21,250 81,250 11,250 0 $176,250
$37,500 25,000 21,250 81,250 11,250 0 $176,250
$37,500 25,000 21,250 81,250 11,250 0 $176,250
$37,500 25,000 21,250 81,250 11,250 0 $176,250
$150,000 100,000 85,000 325,000 45,000 0 $705,000
1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 8.00 66.00
1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 8.00 66.00
1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 8.00 67.00
1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 8.00 67.00
4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 0.00 20.00 254.00
$135,000 105,000 90,000 75,000 75,000 90,000 70,000 50,000
$33,750 26,250 22,500 18,750 18,750 22,500 17,500 12,500 0 $172,500 $1,646,250
$33,750 26,250 22,500 18,750 18,750 22,500 17,500 12,500 0 $172,500 $1,651,250
$33,750 26,250 22,500 18,750 18,750 22,500 17,500 12,500 0 $172,500 $1,671,250
$33,750 26,250 22,500 18,750 18,750 22,500 17,500 12,500 0 $172,500 $1,671,250
$135,000 105,000 90,000 75,000 75,000 90,000 70,000 50,000 0 $690,000 $6,640,000
KEY MODEL INPUTS
Fringe benefit percentage Fiscal revenue 25.0% $5,256,000
SUMMARY DATA BY DEPARTMENT
Department Executive Finance Human Resources Information Technology Accounting Sales Operations Marketing Corporate Totals Total number of employees 20 24 40 42 28 44 36 20 254 Total salary $1,240,000 680,000 835,000 950,000 540,000 1,000,000 705,000 690,000 $6,640,000 Benefits $310,000 170,000 208,750 237,500 135,000 250,000 176,250 172,500 $1,660,000 Salary + benefits $1,550,000 850,000 1,043,750 1,187,500 675,000 1,250,000 881,250 862,500 $8,300,000 Variable compensation % 15.0% 10.0% 5.0% 5.0% 5.0% 40.0% 10.0% 5.0% Variable pay $186,000 68,000.00 41,750.00 47,500.00 27,000.00 400,000.00 70,500.00 34,500.00 $875,250 Stock-based compensation $200,000 50,000.00 0.00 0.00 0.00 0.00 0.00 0.00 $250,000 Total compensation $1,936,000 968,000.00 1,085,500.00 1,235,000.00 702,000.00 1,650,000.00 951,750.00 897,000.00 $9,425,250
Department Executive Finance Human Resources Information Technology Accounting Sales Operations Marketing
Total number of employees 20 24 40 42 28 44 36 20 254
% of total
Total comp
% of total 20.5% 10.3% 11.5% 13.1% 7.4% 17.5% 10.1% 9.5% 100.0%
Key metrics: Revenue/employee Total compensation/employee Quarterly metrics:
Salary Benefits Salary + benefits
7.9% $1,936,000 9.4% 968,000 15.7% 1,085,500 16.5% 1,235,000 11.0% 702,000 17.3% 1,650,000 14.2% 951,750 7.9% 897,000 100.0% $9,425,250
$20,693 $37,107
Q1 Q2 Q3 Q4
$1,646,250 1,651,250 1,671,250 1,671,250 $6,640,000
$411,563 412,813 417,813 417,813 $1,660,000
$2,057,813 2,064,063 2,089,063 2,089,063 $8,300,000
Quarterly Analysis of Salary and Benefits
$2,500,000
$2,000,000
$1,500,000
Salary Benefits Salary + benefits
$1,000,000
$500,000
$0 Q1 Q2 Q3 Q4
Quarter