$12.99
Document provided by...
pagosspreadsheetzone
www.spreadsheetzone.com
About This Document
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.
Stats
Type:
Excel Spreadsheet
Size:
90 kb
Pages:
18
Views:
923
Posted:
08/02/09
Categories
DocStore > Templates > Spreadsheets
Tags
payroll calculator, payroll software, payroll, payroll taxes, payroll services, payroll template, payroll templates

Headcount and Payroll Planner

View, download, and print this entire document by purchasing it for only $12.99
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