Headcount and Payroll Planner - Excel by pagosspreadsheetzone

VIEWS: 6,595 PAGES: 18

More Info
									ABC, Inc.
Headcount
Q1 Chief executive officer Chief financial officer Chief operating officer Chief information officer President Q2 Q3

2009 Headcount

Q4

Executive

Vice president Financial planning director Financial analyst Credit analyst Advisor

Finance

Vice president Director Senior human resource representative Benefits coordinator Human Resources Compensation manager Human resource generalist

Information Technology

Vice president Director Systems engineer Systems analyst Technician Support

Accounting

Vice president Controller Accounting manager Accounts receivable Accounts payable Treasury

Vice president

Sales

Sales

Regional director Business development Direct sales representative Inside sales Sales operations

Operations

Vice president Director Manager Floor manager Assistant

Marketing

Vice president Director Product manager Market research Market analyst Product manager

2009 Headcount and Payroll Plan
Annual Salary

Cost
Q1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Q2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Q3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Q4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

CALCULATIONS q1 d1 d2 d3 d4 d5 d6 d7 d8 t 0 0 0 0 0 0 0 0 0 number q2 q3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 q4 0 0 0 0 0 0 0 0 0 t 0 0 0 0 0 0 0 0 0 q1 0 0 0 0 0 0 0 0 0 cost q2 q3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 q4 0 0 0 0 0 0 0 0 0 t 0 0 0 0 0 0 0 0 0 vc 0 0 0 0 0 0 0 0 vp1 0 0 0 0 0 0 0 0 0 vp2 0 0 0 0 0 0 0 0 0 vp3 0 0 0 0 0 0 0 0 0

vp4 0 0 0 0 0 0 0 0 0

t 0 0 0 0 0 0 0 0 0

b1 0 0 0 0 0 0 0 0 0

b2 0 0 0 0 0 0 0 0 0

b3 0 0 0 0 0 0 0 0 0

b4 0 0 0 0 0 0 0 0 0

t sbc1 sbc2 sbc3 sbc4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

t 0 0 0 0 0 0 0 0 0

tc1 0 0 0 0 0 0 0 0 0

tc2 0 0 0 0 0 0 0 0 0

tc3 0 0 0 0 0 0 0 0 0

tc4 0 0 0 0 0 0 0 0 0

tct 0 0 0 0 0 0 0 0 0

Executive Finance Human Resources Information Techno Accounting Sales Operations Marketing

0 0 0 0 0 0 0 0

Q1 Q2 Q3 Q4

0 0 0 0

0 0 0 0

Salaries Benefits Variable Stock Based

0 0 0 0

ABC, Inc.
Fiscal Revenue: 0

2009 Headcount and Payr
Total Compensation:

Compensation Distribution
Salaries Benefits
Variable

0% Marketing Operations
Sales

Total Compensations

Accounting Information Technology
Human Resources

Stock Based

Finance Executive 0

Compensation and Revenue Averages
								
To top