Headcount and Payroll Planner - Excel

Document Sample
Headcount and Payroll Planner - Excel Powered By Docstoc
					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
				
DOCUMENT INFO
Description: This file is prepared for recording and analyzing the headcount and payroll information of companies. Up to 8 departments and 8 job titles for each department may be used in this file. Number of employees in each job title at each quarter are tracked on a sheet. Also, the salaries of these job titles are recorded. A dashboard sheet provides the analysis of the number of employees and salaries. All compensations (salaries, benefits, variable compensations and stock based compensations) are calculated and displayed on the dashboard sheet. The charts provides information about the distribution of compensations over quarters, departments and compensation categories. Revenue and comensation per employee are also calculated. Finally, combo boxes allow to reach the compensation summary of any department or quarter easily.
BUY THIS DOCUMENT NOW PRICE: $12.99 100% MONEY BACK GUARANTEED
PARTNER SpreadsheetZone
SpreadsheetZONE features one of the biggest Microsoft Excel template repositories on the web. Supported by an active community and Excel Pros SpreadsheetZONE grows rapidly, delivering new templates everyday. Find the template you need now!