ABC, Inc.
Headcount
Q1 Chief executive officer Chief financial officer Chief operating officer Executive Chief information officer President 0 0 0 0 0 0 0 0 Vice president Financial planning director Financial analyst Finance Credit analyst Advisor 0 0 0 0 0 0 0 0 Vice president Director Senior human resource representative Human Resources Benefits coordinator Compensation manager Human resource generalist 0 0 0 0 0 0 0 0 Vice president Director Systems engineer Information Technology Systems analyst Technician Support 0 0 0 0 0 0 0 0 Vice president Controller Accounting manager Accounting Accounts receivable Accounts payable Treasury 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 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
2009 Headco
Accounting
0 Vice president Regional director Business development Sales Direct sales representative Inside sales Sales operations 0 0 0 0 0 0 0 0 Vice president Director Manager Operations Floor manager Assistant 0 0 0 0 0 0 0 0 Vice president Director Product manager Marketing Market research Market analyst Product manager 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2009 Headcount and Payroll Plan
Annual Salary 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
adcount
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
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 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 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 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 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 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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 0 Finance 0
Q1 Q2
0 0 0 0
0 0 0 0
Salaries Benefits Variable Stock Based
0 0 0 0
Human Resources Q3 0 Information Technology 0 Q4 Accounting0 Sales 0 Operations0 Marketing 0
ABC, Inc.
Fiscal Revenue: 0
2009 Headcount and Payr
Total Compensation:
Marketing Operations Salaries Benefits Variable
Stock Based
Accounting Information Technology Human Resources
Executive
Revenue per Employee Total Compensation per Employee
0 0
Q1 Q2 Q3 Q4 ALL
0% 0% 0% 0%
ALL Total Number of Employees 0
% of Total 0%
Total Salary 0
Benefits 0
Salary+Benefits 0
Variable Pay 0
9 Headcount and Payroll Plan
Compensation: 0
Marketing Operations Sales
Accounting
nformation Technology Human Resources Finance Executive 0 0.2 0.4 0.6 0.8 1
0% 0% 0% 0%
Variable Pay 0
Stock Based Compensation 0
Total Compensation 0
% of Total 0%
9
5█
Follow the steps to enable your online Headcount and Payroll Tracker.
1) 2) 3) 4) >> You will see sample departments and titles. You need to delete the ones that you will not use. What is the Fringe Benefit Percentage? Type the name of your company: Type the fiscal year: The dashboard will be created automatically. Further steps are for online use. 5) Visit the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password to create your online Headcount and Payroll Tracker. 6) Visit the site below: https://www4.spreadsheetweb.com/SpreadsheetWEB// Login to page with your new account information. 7) a planning horizon. Your online Headcount and Payroll Tracker will be created automatically. You can simply use the Headcount and Payroll Tracker from that link or place it on your website. >> >> Your online Headcount and Payroll Tracker will look like: http://www1.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=78e7f16f-a3a7-4040-aea2-d3058b53f036 In order to see more online applications created with SpreadsheetWEB you can check the link below: http://www.spreadsheetweb.com/demos.htm 2009 25.00% ABC, Inc.
Provide the Department and Job Title information on the "Data" sheet. 8 departments and 8 job titles for each are allowed in this tra
Your Headcount and Payroll Tracker is ready to use. Now you can enter the headcount and payroll information on the "Headcount"
Click "Add Web Application" to upload this file. Check "Single Record Application". This will allow you to use and update the same fil
Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/
racker.
for each are allowed in this tracker.
ormation on the "Headcount" sheet.
o use and update the same file over
0-aea2-d3058b53f036
ALL Executive
9 ALL
5 1 2 3 4
1 Q1 Finance 2 Q2 Human Resources 3 Q3 Information 4 Q4 Technology Accounting 5 Sales 6 Operations 7 Marketing 8 ABC, Inc. 2009
Department 1 2 3 4 5 6
11 12 13 14 15 16
Executive
Job Title Chief executive officer Chief financial officer Chief operating officer Chief information officer President
51 52 53
Accounting
41 42 43 44 45 46
Information Technology
31 32 33 34 35 36
Human Resources
21 22 23 24 25 26
Finance
Vice president Financial planning director Financial analyst Credit analyst Advisor
Department Executive Finance Human Resources Information Technology Accounting Sales Operations Marketing Fiscal Revenue
Vice president Director Senior human resource representative Benefits coordinator Compensation manager Human resource generalist
Vice president Director Systems engineer Systems analyst Technician Support
Vice president Controller Accounting manager Accounts receivable Accounts payable Treasury
Vice president Regional director Business development
Sales
54 55 56
Sales Operations Marketing
Direct sales representative Inside sales Sales operations
61 62 63 64 65 66
Vice president Director Manager Floor manager Assistant
71 72 73 74 75 76
Vice president Director Product manager Market research Market analyst Product manager
rtment utive ce an Resources mation Technology unting
Variable (%) Compensation
Stock Based Compensation
ations eting Revenue