Headcount And Payroll Planner
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Headcount And Payroll Planner as PDF for free.
More details
- Words: 1,815
- Pages: 54
Headcount Headcount
Executive
Finance
Human Resources
Information Technology
Accounting
Q1
Q2
Q3
Chief executive officer
0
0
0
Chief financial officer
0
0
0
Chief operating officer
0
0
0
Chief information officer
0
0
0
President
0
0
0
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Financial planning director
0
0
0
Financial analyst
0
0
0
Credit analyst
0
0
0
Advisor
0
0
0
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Director
0
0
0
Senior human resource representative
0
0
0
Benefits coordinator
0
0
0
Compensation manager
0
0
0
Human resource generalist
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Director
0
0
0
Systems engineer
0
0
0
Systems analyst
0
0
0
Technician
0
0
0
Support
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Controller
0
0
0
Accounting manager
0
0
0
Accounts receivable
0
0
0
Accounts payable
0
0
0
Treasury
0
0
0
0
0
0
Sales
Operations
Marketing
0
0
0
Vice president
0
0
0
Regional director
0
0
0
Business development
0
0
0
Direct sales representative
0
0
0
Inside sales
0
0
0
Sales operations
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Director
0
0
0
Manager
0
0
0
Floor manager
0
0
0
Assistant
0
0
0
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Director
0
0
0
Product manager
0
0
0
Market research
0
0
0
Market analyst
0
0
0
Product manager
0
0
0
0
0
0
0
0
0
Headcount and Payroll Plan
dcount Q4
Annual Salary
Cost Q1
Q2
Q3
Q4
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
number
cost
q1
q2
q3
q4
t
q1
q2
q3
q4
t
vc vp1 vp2
d1
0
0
0
0
0
0
0
0
0
0
0
0
0
d2
0
0
0
0
0
0
0
0
0
0
0
0
0
d3
0
0
0
0
0
0
0
0
0
0
0
0
0
d4
0
0
0
0
0
0
0
0
0
0
0
0
0
d5
0
0
0
0
0
0
0
0
0
0
0
0
0
d6
0
0
0
0
0
0
0
0
0
0
0
0
0
d7
0
0
0
0
0
0
0
0
0
0
0
0
0
d8
0
0
0
0
0
0
0
0
0
0
0
0
0
t
0
0
0
0
0
0
0
0
0
0
0
0
vp3 vp4
t
b1
b2
b3
b4
t sbc1 sbc2 sbc3 sbc4
t
tc1
tc2
tc3
tc4
tct
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Executive0
Q1
0
0
Salaries
0
Finance 0
Q2
0
0
Benefits
0
Human Resources 0 Q3
0
0
Variable
0
Information 0 Technology Q4 0
0
Stock Based
0
Accounting 0 Sales
0
Operations 0 Marketing 0
Headcount and Pay Fiscal Revenue:
0
Total Compensation:
Salaries Benefits Variable Stock Based
Marketing Operations Sales Accounting Information Technology Human Resources Finance Executive
Revenue per Employee
0
Q1
0%
Total Compensation per Employee
0
Q2
0%
Q3
0%
Q4
0%
ALL Total Number of Employees % of Total 0
0%
ALL
Total Salary 0
Benefits Salary+BenefitsVariable Pay 0
0
0
adcount and Payroll Plan
al Compensation:
0
Marketing Operations Sales Accounting mation Technology Human Resources Finance Executive 1
1
1
0% 0% 0% 0%
Stock Based Total Variable Pay CompensationCompensation 0
0
0
% of Total 0%
1
1
9
5█
Follow the steps to enable your online Headcount and Payrol
1) Provide the Department and Job Title information on the "Data" sheet. 8 departments and 8 job titles for ea You will see sample departments and titles. You need to delete the ones that you will not use. 2) What is the Fringe Benefit Percentage?
25.00%
3) Type the name of your company: 4) Type the fiscal year:
ABC, Inc. 2009
>> Your Headcount and Payroll Tracker is ready to use. Now you can enter the headcount and payroll informat 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) Click "Add Web Application" to upload this file. Check "Single Record Application". This will allow you to use 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 >> In order to see more online applications created with SpreadsheetWEB you can check the link below: http://www.spreadsheetweb.com/demos.htm
Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/
unt and Payroll Tracker.
ents and 8 job titles for each are allowed in this tracker. will not use.
ount and payroll information on the "Headcount" sheet.
nd Payroll Tracker.
This will allow you to use and update the same file over
n your website.
78e7f16f-a3a7-4040-aea2-d3058b53f036
heck the link below:
ALL
9 ALL
Executive1 Q1
5
1 2 Finance 2 Q2 3 Q3 3 Human Resources 4 Q4 4 Information Technology 5 Accounting 6 Sales 7 Operations Marketing8 ABC, Inc. 2009
31 32 33 34 35 36
41 42 43 44 45 46
51 52 53
Executive Finance
Human Resources Information Technology
21 22 23 24 25 26
Accounting
11 12 13 14 15 16
Department Job Title Chief executive officer Chief financial officer Chief operating officer Chief information officer President
Sales
1 2 3 4 5 6
Vice president Financial planning director Financial analyst Credit analyst Advisor
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
Department Executive Finance Human Resources Information Technology Accounting Sales Operations Marketing Fiscal Revenue
71 72 73 74 75 76
Sales Operations
61 62 63 64 65 66
Marketing
54 55 56
Direct sales representative Inside sales Sales operations
Vice president Director Manager Floor manager Assistant
Vice president Director Product manager Market research Market analyst Product manager
partment cutive nce man Resources rmation Technology ounting s rations keting
al Revenue
Variable (%) Stock Based Compensation Compensation
%3c%3fxml+version%3d%221.0%22+encoding%3d%22utf-16%22%3f%3e%0d%0a%3cWizardSettin color%3a+%237F7F7F+%3bbackground-color%3a%23376091%3b+text-align%3acenter% 3ePSWMergedSavingCell_0_180%3c%2fName%3e%0d%0a++++++++%3c%2fM ntrolVisible%3efalse%3c%2fIsControlVisible%3e%0d%0a+++++++++ ues+%2f%3e%0d%0a++++++++++++%3cIsControlEnabl efalse%3c%2fAllowRounding%3e%0d%0a++++++ +++++++++++%3cNegativePattern+ parator+%2f%3e%0d%0a+++ ++++++++++++%
UEsFBgAAAAAAAAAAAAAAAAAAAAAAAA%3d%3d
%3c%2fIsRequired%3e%0d%0a++++++++++++%3cTypeName%3eText+Box%3c%2fTypeName% %3c%2fIsDisablingEnabled%3e%0d%0a++++++++++++%3cRequiresValidation%3efals x%3e209%3c%2fNameIndex%3e%0d%0a++++++++++++%3cIsHidingEnable %24Q%2452%3c%2fAddress%3e%0d%0a++++++++++++%3cListIt alse%3c%2fIsControlVisible%3e%0d%0a++++++++++%3 +++++++++%3cListValues+%2f%3e%0d%0a++ n+%2f%3e%0d%0a++++++++++++% mula%3eFalse%3c%2fCellHasF 2fHeight%3e%0d%0
+++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d%0a++++++++++++++++%3cFontSize%3 3e0%3c%2fType%3e%0d%0a++++++++++++++++++%3cNameIndex%3e3%3c%2fN Grid+%2f%3e%0d%0a++++++++++++++%3c%2fTD%3e%0d%0a+++++++ +++++++++%3cDecimalSeparator+%2f%3e%0d%0a+++++++++ %23%230%3c%2fFormat%3e%0d%0a++++++++++++++ CFormated%3efalse%3c%2fPSCFormated%3e%0d mula%3eTrue%3c%2fCellHasFormula%3 +++++++++++++%3cIsCon ages+%2f%3e%0d%
++++++++++++%3cText+%2f%3e%0d%0a++++++++++++++++%3cHeight%3e15.75%3c% ++++++++++++++%3cCellHasFormula%3eFalse%3c%2fCellHasFormula%3e%0d%0a+ +++++++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d%0a+++++ %0d%0a++++++++++++++++%3cColSpan+%2f%3e%0d%0a+++ 29%3c%2fStyle%3e%0d%0a++++++++++++++++%3cM ++++++++++++++++++%3cAddress%3e%3d eight%3e%0d%0a++++++++++++++ alueType%3e%0d%0a+++++ ++++++%3cFontSi
DisablingEnabled%3efalse%3c%2fIsDisablingEnabled%3e%0d%0a++++++++++++++++++%3c 0a++++++++++++++++++%3cTypeName%3eText+Box%3c%2fTypeName%3e%0d% +++++%3cVerticalAlign%3eCenter%3c%2fVerticalAlign%3e%0d%0a+++++++ +++++%3cIsControlEnabled%3efalse%3c%2fIsControlEnabled%3e%0 %0a++++++++++++++%3c%2fTD%3e%0d%0a++++++ malDigits%3e0%3c%2fDecimalDigits%3e%0d%0a+ ++%3cColSpan+%2f%3e%0d%0a++++ +++++++++++++%3cTD% icalAlign%3e%0d%0
Name%3e%0d%0a++++++++++++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d%0a+ Y%3e%0d%0a++++++++++++++++%3cImages+%2f%3e%0d%0a++++++++++++ %0a++++++++++++++++%3cWidth%3e40.5%3c%2fWidth%3e%0d%0a+++ ++++++++++++%3cVerticalAlign%3eCenter%3c%2fVerticalAlign%3 3e%0d%0a++++++++++++++++%3cFontName%3eCali sHidingEnabled%3e%0d%0a++++++++++++++ mated%3efalse%3c%2fPSCFormated%3e 4%3c%2fX%3e%0d%0a++++ 75%3c%2fWidth%3e
3cDefaultValue%3e0%3c%2fDefaultValue%3e%0d%0a++++++++++++++++++%3cValueType% Calibri%3c%2fFontName%3e%0d%0a++++++++++++++++%3cWrapText%3eFalse%3 %3cIsControlVisible%3efalse%3c%2fIsControlVisible%3e%0d%0a++++++++++ Grid+%2f%3e%0d%0a++++++++++++++%3c%2fTD%3e%0d%0a+ cHeight%3e15.75%3c%2fHeight%3e%0d%0a+++++++++ tFormat%3eNumber%3c%2fTextFormat%3e%0d% 3cImages+%2f%3e%0d%0a++++++++ +++++++++%3cFormat%3e e%3eFalse%3c%2fM
False%3c%2fWrapText%3e%0d%0a++++++++++++++++%3cFontSize%3e10%3c%2fFontSize% rapText%3eFalse%3c%2fWrapText%3e%0d%0a++++++++++++++++%3cFontSize%3 %3cStyle%3eClass351%3c%2fStyle%3e%0d%0a++++++++++++++++%3cM er%3c%2fVerticalAlign%3e%0d%0a++++++++++++++++%3cCellH 2fAlign%3e%0d%0a++++++++++++++++%3cVerticalAl CFormated%3e%0d%0a++++++++++++++++ ontName%3e%0d%0a+++++++++++ d%0a+++++++++++++++ fY%3e%0d%0a++++
2fHeight%3e%0d%0a++++++++++++++++%3cAlign%3eLeft%3c%2fAlign%3e%0d%0a++++++ %3e%0d%0a++++++++++++++%3cTD%3e%0d%0a++++++++++++++++%3cPSC +++++++++++++++%3cCellHasFormula%3eFalse%3c%2fCellHasFormula%3 c%2fStyle%3e%0d%0a++++++++++++++++%3cMerge%3eFalse% +++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d f%3e%0d%0a++++++++++++++++%3cForma e%0d%0a++++++++++++++++%3c sFormula%3e%0d%0a+++++ %0a++++++++++
ibri%3c%2fFontName%3e%0d%0a++++++++++++++++%3cWrapText%3eFalse%3c%2fWrapTex +++++++++++++%3cGrid+%2f%3e%0d%0a++++++++++++++%3c%2fTD%3e%0d f%3e%0d%0a++++++++++++++++%3cFormControls+%2f%3e%0d%0a+++ asFormula%3e%0d%0a++++++++++++++++%3cFontName%3eCa 9%3c%2fStyle%3e%0d%0a++++++++++++++++%3cMe %2fFontName%3e%0d%0a++++++++++++++ %0d%0a++++++++++++++%3c%2fT ++++++++%3cFormat%3eG +++++++++++++
+++++++++++++%3cPSCFormated%3efalse%3c%2fPSCFormated%3e%0d%0a++++++++++++++++%
++++++++++++%3cStyle%3eClass292%3c%2fStyle%3e%0d%0a++++++++++++++++%3cMerge%3eFa
+++%3cMerge%3eFalse%3c%2fMerge%3e%0d%0a++++++++++++++++%3cRowSpan+%2f%3e%0d%0a+
n+%2f%3e%0d%0a++++++++++++++++%3cColSpan+%2f%3e%0d%0a++++++++++++++++%3cFo
+++++++++%3cFormat%3eGeneral%3c%2fFormat%3e%0d%0a++++++++++++++++%3cWidth%3e66.7
+%3cWidth%3e66.75%3c%2fWidth%3e%0d%0a++++++++++++++++%3cText+%2f%3e%0d%0a+++++
%3e%0d%0a++++++++++++++++%3cHeight%3e15%3c%2fHeight%3e%0d%0a++++++++++++++++
+++++++++++++%3cAlign%3eLeft%3c%2fAlign%3e%0d%0a++++++++++++++++%3cVerticalAlign+%
+%3cVerticalAlign+%2f%3e%0d%0a++++++++++++++++%3cCellHasFormula%3eFalse%3c%2fCellHasFor
se%3c%2fCellHasFormula%3e%0d%0a++++++++++++++++%3cFontName%3eCalibri%3c%2fFontName%3
%3c%2fFontName%3e%0d%0a++++++++++++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d%0
WrapText%3e%0d%0a++++++++++++++++%3cFontSize%3e11%3c%2fFontSize%3e%0d%0a++++++++
%0d%0a++++++++++++++++%3cX%3e11%3c%2fX%3e%0d%0a++++++++++++++++%3cY%3e31%3
+++%3cY%3e31%3c%2fY%3e%0d%0a++++++++++++++++%3cImages+%2f%3e%0d%0a+++++++++
0d%0a++++++++++++++++%3cFormControls+%2f%3e%0d%0a++++++++++++++++%3cGrid+%2f%
++++%3cGrid+%2f%3e%0d%0a++++++++++++++%3c%2fTD%3e%0d%0a++++++++++++++%3cTD%
++++++++%3cTD%3e%0d%0a++++++++++++++++%3cPSCFormated%3efalse%3c%2fPSCFormated%3e
%2fPSCFormated%3e%0d%0a++++++++++++++++%3cStyle%3eClass292%3c%2fStyle%3e%0d%0a++++
yle%3e%0d%0a++++++++++++++++%3cMerge%3eFalse%3c%2fMerge%3e%0d%0a+++++++++++++
%0a++++++++++++++++%3cRowSpan+%2f%3e%0d%0a++++++++++++++++%3cColSpan+%2f%3e%
+++++%3cColSpan+%2f%3e%0d%0a++++++++++++++++%3cFormat%3eGeneral%3c%2fFormat%3e%0
General%3c%2fFormat%3e%0d%0a++++++++++++++++%3cWidth%3e24.75%3c%2fWidth%3e%0d%0a+
75%3c%2fWidth%3e%0d%0a++++++++++++++++%3cText+%2f%3e%0d%0a++++++++++++++++%
0a++++++++++++++++%3cHeight%3e15%3c%2fHeight%3e%0d%0a++++++++++++++++%3cAlign%
Executive
Finance
Human Resources
Information Technology
Accounting
Q1
Q2
Q3
Chief executive officer
0
0
0
Chief financial officer
0
0
0
Chief operating officer
0
0
0
Chief information officer
0
0
0
President
0
0
0
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Financial planning director
0
0
0
Financial analyst
0
0
0
Credit analyst
0
0
0
Advisor
0
0
0
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Director
0
0
0
Senior human resource representative
0
0
0
Benefits coordinator
0
0
0
Compensation manager
0
0
0
Human resource generalist
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Director
0
0
0
Systems engineer
0
0
0
Systems analyst
0
0
0
Technician
0
0
0
Support
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Controller
0
0
0
Accounting manager
0
0
0
Accounts receivable
0
0
0
Accounts payable
0
0
0
Treasury
0
0
0
0
0
0
Sales
Operations
Marketing
0
0
0
Vice president
0
0
0
Regional director
0
0
0
Business development
0
0
0
Direct sales representative
0
0
0
Inside sales
0
0
0
Sales operations
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Director
0
0
0
Manager
0
0
0
Floor manager
0
0
0
Assistant
0
0
0
0
0
0
0
0
0
0
0
0
Vice president
0
0
0
Director
0
0
0
Product manager
0
0
0
Market research
0
0
0
Market analyst
0
0
0
Product manager
0
0
0
0
0
0
0
0
0
Headcount and Payroll Plan
dcount Q4
Annual Salary
Cost Q1
Q2
Q3
Q4
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
number
cost
q1
q2
q3
q4
t
q1
q2
q3
q4
t
vc vp1 vp2
d1
0
0
0
0
0
0
0
0
0
0
0
0
0
d2
0
0
0
0
0
0
0
0
0
0
0
0
0
d3
0
0
0
0
0
0
0
0
0
0
0
0
0
d4
0
0
0
0
0
0
0
0
0
0
0
0
0
d5
0
0
0
0
0
0
0
0
0
0
0
0
0
d6
0
0
0
0
0
0
0
0
0
0
0
0
0
d7
0
0
0
0
0
0
0
0
0
0
0
0
0
d8
0
0
0
0
0
0
0
0
0
0
0
0
0
t
0
0
0
0
0
0
0
0
0
0
0
0
vp3 vp4
t
b1
b2
b3
b4
t sbc1 sbc2 sbc3 sbc4
t
tc1
tc2
tc3
tc4
tct
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Executive0
Q1
0
0
Salaries
0
Finance 0
Q2
0
0
Benefits
0
Human Resources 0 Q3
0
0
Variable
0
Information 0 Technology Q4 0
0
Stock Based
0
Accounting 0 Sales
0
Operations 0 Marketing 0
Headcount and Pay Fiscal Revenue:
0
Total Compensation:
Salaries Benefits Variable Stock Based
Marketing Operations Sales Accounting Information Technology Human Resources Finance Executive
Revenue per Employee
0
Q1
0%
Total Compensation per Employee
0
Q2
0%
Q3
0%
Q4
0%
ALL Total Number of Employees % of Total 0
0%
ALL
Total Salary 0
Benefits Salary+BenefitsVariable Pay 0
0
0
adcount and Payroll Plan
al Compensation:
0
Marketing Operations Sales Accounting mation Technology Human Resources Finance Executive 1
1
1
0% 0% 0% 0%
Stock Based Total Variable Pay CompensationCompensation 0
0
0
% of Total 0%
1
1
9
5█
Follow the steps to enable your online Headcount and Payrol
1) Provide the Department and Job Title information on the "Data" sheet. 8 departments and 8 job titles for ea You will see sample departments and titles. You need to delete the ones that you will not use. 2) What is the Fringe Benefit Percentage?
25.00%
3) Type the name of your company: 4) Type the fiscal year:
ABC, Inc. 2009
>> Your Headcount and Payroll Tracker is ready to use. Now you can enter the headcount and payroll informat 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) Click "Add Web Application" to upload this file. Check "Single Record Application". This will allow you to use 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 >> In order to see more online applications created with SpreadsheetWEB you can check the link below: http://www.spreadsheetweb.com/demos.htm
Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/
unt and Payroll Tracker.
ents and 8 job titles for each are allowed in this tracker. will not use.
ount and payroll information on the "Headcount" sheet.
nd Payroll Tracker.
This will allow you to use and update the same file over
n your website.
78e7f16f-a3a7-4040-aea2-d3058b53f036
heck the link below:
ALL
9 ALL
Executive1 Q1
5
1 2 Finance 2 Q2 3 Q3 3 Human Resources 4 Q4 4 Information Technology 5 Accounting 6 Sales 7 Operations Marketing8 ABC, Inc. 2009
31 32 33 34 35 36
41 42 43 44 45 46
51 52 53
Executive Finance
Human Resources Information Technology
21 22 23 24 25 26
Accounting
11 12 13 14 15 16
Department Job Title Chief executive officer Chief financial officer Chief operating officer Chief information officer President
Sales
1 2 3 4 5 6
Vice president Financial planning director Financial analyst Credit analyst Advisor
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
Department Executive Finance Human Resources Information Technology Accounting Sales Operations Marketing Fiscal Revenue
71 72 73 74 75 76
Sales Operations
61 62 63 64 65 66
Marketing
54 55 56
Direct sales representative Inside sales Sales operations
Vice president Director Manager Floor manager Assistant
Vice president Director Product manager Market research Market analyst Product manager
partment cutive nce man Resources rmation Technology ounting s rations keting
al Revenue
Variable (%) Stock Based Compensation Compensation
%3c%3fxml+version%3d%221.0%22+encoding%3d%22utf-16%22%3f%3e%0d%0a%3cWizardSettin color%3a+%237F7F7F+%3bbackground-color%3a%23376091%3b+text-align%3acenter% 3ePSWMergedSavingCell_0_180%3c%2fName%3e%0d%0a++++++++%3c%2fM ntrolVisible%3efalse%3c%2fIsControlVisible%3e%0d%0a+++++++++ ues+%2f%3e%0d%0a++++++++++++%3cIsControlEnabl efalse%3c%2fAllowRounding%3e%0d%0a++++++ +++++++++++%3cNegativePattern+ parator+%2f%3e%0d%0a+++ ++++++++++++%
UEsFBgAAAAAAAAAAAAAAAAAAAAAAAA%3d%3d
%3c%2fIsRequired%3e%0d%0a++++++++++++%3cTypeName%3eText+Box%3c%2fTypeName% %3c%2fIsDisablingEnabled%3e%0d%0a++++++++++++%3cRequiresValidation%3efals x%3e209%3c%2fNameIndex%3e%0d%0a++++++++++++%3cIsHidingEnable %24Q%2452%3c%2fAddress%3e%0d%0a++++++++++++%3cListIt alse%3c%2fIsControlVisible%3e%0d%0a++++++++++%3 +++++++++%3cListValues+%2f%3e%0d%0a++ n+%2f%3e%0d%0a++++++++++++% mula%3eFalse%3c%2fCellHasF 2fHeight%3e%0d%0
+++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d%0a++++++++++++++++%3cFontSize%3 3e0%3c%2fType%3e%0d%0a++++++++++++++++++%3cNameIndex%3e3%3c%2fN Grid+%2f%3e%0d%0a++++++++++++++%3c%2fTD%3e%0d%0a+++++++ +++++++++%3cDecimalSeparator+%2f%3e%0d%0a+++++++++ %23%230%3c%2fFormat%3e%0d%0a++++++++++++++ CFormated%3efalse%3c%2fPSCFormated%3e%0d mula%3eTrue%3c%2fCellHasFormula%3 +++++++++++++%3cIsCon ages+%2f%3e%0d%
++++++++++++%3cText+%2f%3e%0d%0a++++++++++++++++%3cHeight%3e15.75%3c% ++++++++++++++%3cCellHasFormula%3eFalse%3c%2fCellHasFormula%3e%0d%0a+ +++++++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d%0a+++++ %0d%0a++++++++++++++++%3cColSpan+%2f%3e%0d%0a+++ 29%3c%2fStyle%3e%0d%0a++++++++++++++++%3cM ++++++++++++++++++%3cAddress%3e%3d eight%3e%0d%0a++++++++++++++ alueType%3e%0d%0a+++++ ++++++%3cFontSi
DisablingEnabled%3efalse%3c%2fIsDisablingEnabled%3e%0d%0a++++++++++++++++++%3c 0a++++++++++++++++++%3cTypeName%3eText+Box%3c%2fTypeName%3e%0d% +++++%3cVerticalAlign%3eCenter%3c%2fVerticalAlign%3e%0d%0a+++++++ +++++%3cIsControlEnabled%3efalse%3c%2fIsControlEnabled%3e%0 %0a++++++++++++++%3c%2fTD%3e%0d%0a++++++ malDigits%3e0%3c%2fDecimalDigits%3e%0d%0a+ ++%3cColSpan+%2f%3e%0d%0a++++ +++++++++++++%3cTD% icalAlign%3e%0d%0
Name%3e%0d%0a++++++++++++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d%0a+ Y%3e%0d%0a++++++++++++++++%3cImages+%2f%3e%0d%0a++++++++++++ %0a++++++++++++++++%3cWidth%3e40.5%3c%2fWidth%3e%0d%0a+++ ++++++++++++%3cVerticalAlign%3eCenter%3c%2fVerticalAlign%3 3e%0d%0a++++++++++++++++%3cFontName%3eCali sHidingEnabled%3e%0d%0a++++++++++++++ mated%3efalse%3c%2fPSCFormated%3e 4%3c%2fX%3e%0d%0a++++ 75%3c%2fWidth%3e
3cDefaultValue%3e0%3c%2fDefaultValue%3e%0d%0a++++++++++++++++++%3cValueType% Calibri%3c%2fFontName%3e%0d%0a++++++++++++++++%3cWrapText%3eFalse%3 %3cIsControlVisible%3efalse%3c%2fIsControlVisible%3e%0d%0a++++++++++ Grid+%2f%3e%0d%0a++++++++++++++%3c%2fTD%3e%0d%0a+ cHeight%3e15.75%3c%2fHeight%3e%0d%0a+++++++++ tFormat%3eNumber%3c%2fTextFormat%3e%0d% 3cImages+%2f%3e%0d%0a++++++++ +++++++++%3cFormat%3e e%3eFalse%3c%2fM
False%3c%2fWrapText%3e%0d%0a++++++++++++++++%3cFontSize%3e10%3c%2fFontSize% rapText%3eFalse%3c%2fWrapText%3e%0d%0a++++++++++++++++%3cFontSize%3 %3cStyle%3eClass351%3c%2fStyle%3e%0d%0a++++++++++++++++%3cM er%3c%2fVerticalAlign%3e%0d%0a++++++++++++++++%3cCellH 2fAlign%3e%0d%0a++++++++++++++++%3cVerticalAl CFormated%3e%0d%0a++++++++++++++++ ontName%3e%0d%0a+++++++++++ d%0a+++++++++++++++ fY%3e%0d%0a++++
2fHeight%3e%0d%0a++++++++++++++++%3cAlign%3eLeft%3c%2fAlign%3e%0d%0a++++++ %3e%0d%0a++++++++++++++%3cTD%3e%0d%0a++++++++++++++++%3cPSC +++++++++++++++%3cCellHasFormula%3eFalse%3c%2fCellHasFormula%3 c%2fStyle%3e%0d%0a++++++++++++++++%3cMerge%3eFalse% +++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d f%3e%0d%0a++++++++++++++++%3cForma e%0d%0a++++++++++++++++%3c sFormula%3e%0d%0a+++++ %0a++++++++++
ibri%3c%2fFontName%3e%0d%0a++++++++++++++++%3cWrapText%3eFalse%3c%2fWrapTex +++++++++++++%3cGrid+%2f%3e%0d%0a++++++++++++++%3c%2fTD%3e%0d f%3e%0d%0a++++++++++++++++%3cFormControls+%2f%3e%0d%0a+++ asFormula%3e%0d%0a++++++++++++++++%3cFontName%3eCa 9%3c%2fStyle%3e%0d%0a++++++++++++++++%3cMe %2fFontName%3e%0d%0a++++++++++++++ %0d%0a++++++++++++++%3c%2fT ++++++++%3cFormat%3eG +++++++++++++
+++++++++++++%3cPSCFormated%3efalse%3c%2fPSCFormated%3e%0d%0a++++++++++++++++%
++++++++++++%3cStyle%3eClass292%3c%2fStyle%3e%0d%0a++++++++++++++++%3cMerge%3eFa
+++%3cMerge%3eFalse%3c%2fMerge%3e%0d%0a++++++++++++++++%3cRowSpan+%2f%3e%0d%0a+
n+%2f%3e%0d%0a++++++++++++++++%3cColSpan+%2f%3e%0d%0a++++++++++++++++%3cFo
+++++++++%3cFormat%3eGeneral%3c%2fFormat%3e%0d%0a++++++++++++++++%3cWidth%3e66.7
+%3cWidth%3e66.75%3c%2fWidth%3e%0d%0a++++++++++++++++%3cText+%2f%3e%0d%0a+++++
%3e%0d%0a++++++++++++++++%3cHeight%3e15%3c%2fHeight%3e%0d%0a++++++++++++++++
+++++++++++++%3cAlign%3eLeft%3c%2fAlign%3e%0d%0a++++++++++++++++%3cVerticalAlign+%
+%3cVerticalAlign+%2f%3e%0d%0a++++++++++++++++%3cCellHasFormula%3eFalse%3c%2fCellHasFor
se%3c%2fCellHasFormula%3e%0d%0a++++++++++++++++%3cFontName%3eCalibri%3c%2fFontName%3
%3c%2fFontName%3e%0d%0a++++++++++++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d%0
WrapText%3e%0d%0a++++++++++++++++%3cFontSize%3e11%3c%2fFontSize%3e%0d%0a++++++++
%0d%0a++++++++++++++++%3cX%3e11%3c%2fX%3e%0d%0a++++++++++++++++%3cY%3e31%3
+++%3cY%3e31%3c%2fY%3e%0d%0a++++++++++++++++%3cImages+%2f%3e%0d%0a+++++++++
0d%0a++++++++++++++++%3cFormControls+%2f%3e%0d%0a++++++++++++++++%3cGrid+%2f%
++++%3cGrid+%2f%3e%0d%0a++++++++++++++%3c%2fTD%3e%0d%0a++++++++++++++%3cTD%
++++++++%3cTD%3e%0d%0a++++++++++++++++%3cPSCFormated%3efalse%3c%2fPSCFormated%3e
%2fPSCFormated%3e%0d%0a++++++++++++++++%3cStyle%3eClass292%3c%2fStyle%3e%0d%0a++++
yle%3e%0d%0a++++++++++++++++%3cMerge%3eFalse%3c%2fMerge%3e%0d%0a+++++++++++++
%0a++++++++++++++++%3cRowSpan+%2f%3e%0d%0a++++++++++++++++%3cColSpan+%2f%3e%
+++++%3cColSpan+%2f%3e%0d%0a++++++++++++++++%3cFormat%3eGeneral%3c%2fFormat%3e%0
General%3c%2fFormat%3e%0d%0a++++++++++++++++%3cWidth%3e24.75%3c%2fWidth%3e%0d%0a+
75%3c%2fWidth%3e%0d%0a++++++++++++++++%3cText+%2f%3e%0d%0a++++++++++++++++%
0a++++++++++++++++%3cHeight%3e15%3c%2fHeight%3e%0d%0a++++++++++++++++%3cAlign%
Related Documents
Headcount And Payroll Planner
June 2020 24
Headcount
December 2019 61
Headcount
October 2019 100
Payroll
December 2019 47
Payroll
May 2020 17
Payroll
May 2020 17More Documents from "LouRemiE"
Shifts In Supply Curve
May 2020 15
League Table
May 2020 16
Size Costing
May 2020 16
Polar Coordinates
May 2020 9