Zoho Sheet - Headcount and Payroll Planner.xlsx

Headcount


ABC, Inc.		2009 Headcount and Payroll Plan

		Headcount				Annual Salary	Cost						number					cost
		Q1	Q2	Q3	Q4		Q1	Q2	Q3	Q4	Total		q1	q2	q3	q4	t	q1	q2	q3	q4	t	vc	vp1	vp2	vp3	vp4	t	b1	b2	b3	b4	t	sbc1	sbc2	sbc3	sbc4	t	tc1	tc2	tc3	tc4	tct
Executive	Chief executive officer	0	0	0	0	0	0	0	0	0	0	d1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Executive	0	Q1	0	0	Salaries	0
	Chief financial officer	0	0	0	0	0	0	0	0	0	0	d2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Finance	0	Q2	0	0	Benefits	0
	Chief operating officer	0	0	0	0	0	0	0	0	0	0	d3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Human Resources	0	Q3	0	0	Variable	0
	Chief information officer	0	0	0	0	0	0	0	0	0	0	d4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Information Technology	0	Q4	0	0	Stock Based	0
	President	0	0	0	0	0	0	0	0	0	0	d5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Accounting	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	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Sales	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	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Operations	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	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Marketing	0
Finance	Vice president	0	0	0	0	0	0	0	0	0	0	t	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	Financial planning director	0	0	0	0	0	0	0	0	0	0
	Financial analyst	0	0	0	0	0	0	0	0	0	0
	Credit analyst	0	0	0	0	0	0	0	0	0	0
	Advisor	0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
Human Resources	Vice president	0	0	0	0	0	0	0	0	0	0
	Director	0	0	0	0	0	0	0	0	0	0
	Senior human resource representative	0	0	0	0	0	0	0	0	0	0
	Benefits coordinator	0	0	0	0	0	0	0	0	0	0
	Compensation manager	0	0	0	0	0	0	0	0	0	0
	Human resource generalist	0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
Information Technology	Vice president	0	0	0	0	0	0	0	0	0	0
	Director	0	0	0	0	0	0	0	0	0	0
	Systems engineer	0	0	0	0	0	0	0	0	0	0
	Systems analyst	0	0	0	0	0	0	0	0	0	0
	Technician	0	0	0	0	0	0	0	0	0	0
	Support	0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
Accounting	Vice president	0	0	0	0	0	0	0	0	0	0
	Controller	0	0	0	0	0	0	0	0	0	0
	Accounting manager	0	0	0	0	0	0	0	0	0	0
	Accounts receivable	0	0	0	0	0	0	0	0	0	0
	Accounts payable	0	0	0	0	0	0	0	0	0	0
	Treasury	0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
Sales	Vice president	0	0	0	0	0	0	0	0	0	0
	Regional director	0	0	0	0	0	0	0	0	0	0
	Business development	0	0	0	0	0	0	0	0	0	0
	Direct sales representative	0	0	0	0	0	0	0	0	0	0
	Inside sales	0	0	0	0	0	0	0	0	0	0
	Sales operations	0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
Operations	Vice president	0	0	0	0	0	0	0	0	0	0
	Director	0	0	0	0	0	0	0	0	0	0
	Manager	0	0	0	0	0	0	0	0	0	0
	Floor manager	0	0	0	0	0	0	0	0	0	0
	Assistant	0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
		0	0	0	0	0	0	0	0	0	0
Marketing	Vice president	0	0	0	0	0	0	0	0	0	0
	Director	0	0	0	0	0	0	0	0	0	0
	Product manager	0	0	0	0	0	0	0	0	0	0
	Market research	0	0	0	0	0	0	0	0	0	0
	Market analyst	0	0	0	0	0	0	0	0	0	0
	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

Dashboard


ABC, Inc.						2009 Headcount and Payroll Plan
													9	5	█
Fiscal Revenue:		0				Total Compensation:			0















Revenue per Employee			0			Q1	0%
Total Compensation per Employee			0			Q2	0%
						Q3	0%
						Q4	0%

	ALL			ALL

	Total Number of									Stock Based	Total
	Employees	% of Total	Total Salary	Benefits	Salary+Benefits			Variable Pay		Compensation	Compensation	% of Total
	0	0%	0	0	0			0		0	0	0%

Readme

Follow the steps to enable your online Headcount and Payroll Tracker.

Provide the Department and Job Title information on the "Data" sheet. 8 departments and 8 job titles for each are allowed in this tracker.

ALL

You will see sample departments and titles. You need to delete the ones that you will not use.

What is the Fringe Benefit Percentage?

25.00%

Executive

Type the name of your company:

ABC, Inc.

Finance

Type the fiscal year:

2009

Human Resources

Your Headcount and Payroll Tracker is ready to use. Now you can enter the headcount and payroll information on the "Headcount" sheet.

Information Technology

The dashboard will be created automatically.

Accounting

Further steps are for online use.

Sales

Visit the site below:

Operations

http://www.spreadsheetweb.com/getting_started.htm

Marketing

You will only need the username and password to create your online Headcount and Payroll Tracker.

Visit the site below:

ABC, Inc. 2009

https://www4.spreadsheetweb.com/SpreadsheetWEB//

Click "Add Web Application" to upload this file. Check "Single Record Application". This will allow you to use and update the same file over

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

Data



	Department	Job Title		Variable (%)	Stock Based
1	Executive	Chief executive officer	Department	Compensation	Compensation
2		Chief financial officer	Executive
3		Chief operating officer	Finance
4		Chief information officer	Human Resources
5		President	Information Technology
6			Accounting
			Sales
			Operations
11	Finance	Vice president	Marketing
12		Financial planning director
13		Financial analyst	Fiscal Revenue
14		Credit analyst
15		Advisor
16


21	Human Resources	Vice president
22		Director
23		Senior human resource representative
24		Benefits coordinator
25		Compensation manager
26		Human resource generalist


31	Information Technology	Vice president
32		Director
33		Systems engineer
34		Systems analyst
35		Technician
36		Support


41	Accounting	Vice president
42		Controller
43		Accounting manager
44		Accounts receivable
45		Accounts payable
46		Treasury


51	Sales	Vice president
52		Regional director
53		Business development
54		Direct sales representative
55		Inside sales
56		Sales operations


61	Operations	Vice president
62		Director
63		Manager
64		Floor manager
65		Assistant
66


71	Marketing	Vice president
72		Director
73		Product manager
74		Market research
75		Market analyst
76		Product manager