Time Table Template

Document Sample
Time Table Template Powered By Docstoc
					Employee List
ID 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 Name David Brown Nichola Carter James Oliver Nina Simon Contracted Hours 40.00 20.00 30.00 40.00 Department Accounts HR Lobby/Reception Lobby/Reception

Weekly Time Table
Week Starting Date: Monday, November 30, 2009 Name David Brown Nichola Carter James Oliver Nina Simon Monday
12:00 AM 12:00 AM 12:30 AM OFF 08:00 AM 08:00 AM 05:15 AM OFF

Tuesday
12:00 AM 06:30 PM OFF H 08:00 AM 11:30 PM OFF H

Wednesday
10:00 PM 12:00 AM 12:00 AM H 06:00 AM 07:00 AM 08:15 AM H

Thursday
12:00 AM H 12:00 AM H 08:00 AM H 08:00 AM H

Friday
L 12:00 AM H L 09:00 AM H

Saturday
OFF OFF H OFF OFF H

Sunday
OFF OFF OFF OFF OFF OFF 40:00 28:00 30:00 40:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00 00:00

Employee Name: Department: Week Starting Date: In Mon Tue Wed Thu Fri Sat Sun OFF H H H H H OFF

Nina Simon Lobby/Reception
Monday, November 30, 2009 Out OFF H H H H H OFF In Out

Employee Signature Managers Signature Week Ending Date: ##################

HR & Budget
Current Week Salary Department
Accounts HR Lobby/Reception Administration Customer Support Finance Human Resources IT Marketing R&D Sales

Number of Employees
1 1 2 0 0 0 0 0 0 0 0 $ $ $ $ $ $ $ $ $ $ $

Actual
600.00 336.00 700.00 $ $ $

Budget
900.00

Variance
$ 300.00 136.00 600.00 $ $ $ $ $ $ $ $ $ $ $

Regular Hours
480.00 240.00 300.00 -

Holidays
$ $ $ $ $ $ $ $ $ $ $ 96.00 400.00 -

Public Holidays
$ $ $ $ $ $ $ $ $ $ $ -

Lieu Day
$ $ $ $ $ $ $ $ $ $ $ 120.00 -

Option 6
$ $ $ $ $ $ $ $ $ $ $ -

Salary for: Option 7 Option 8
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ -

Average Salary Option 9
$ $ $ $ $ $ $ $ $ $ $ -

Option 10
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

Sick
$ $ $ $ $ $ $ $ $ $ $

Off
-

Overtime Hours
$ $ $ $ $ $ $ $ $ $ $ 96.00 $ $ $ $ $ $ $ $ $ $ $

Actual
600.00 336.00 350.00 $ $ $ $ $ $ $ $ $ $ $

Budget
900.00 200.00 50.00 -

200.00 -$ 100.00 -$ $ $ $ $ $ $ $ $

4

$

1,636.00

$

1,200.00 -$

436.00

$

1,020.00

$

496.00

$

-

$

120.00

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

96.00

$

409.00

$

300.00

Daily Attendance
Department Accounts HR Lobby/Reception Administration Customer Support Finance Human Resources IT Marketing R&D Sales
Monday Tuesday Wednesday Thursday Friday Saturday Sunday

Average

1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3

1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2

1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3

1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2

0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2

0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1

0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1

Salary Distribution
$800.00 $700.00 $600.00 $500.00 $400.00 $300.00 $200.00 $100.00 $Accounts HRLobby/Reception Administration Customer Finance Human Support Resources IT Marketing R&D Sales Option 10 Option 9 Option 8 Option 7 Option 6 Sick Off Lieu Day Public Holidays Holidays Regular Hours

Average Salary

Sales R&D Marketing IT Human Resources Finance Customer Support Administration Lobby/Reception HR Accounts $$100.00 $200.00 $300.00 $400.00 $500.00 $600.00 $700.00 $800.00 $900.00 $1,000.00

Budget Actual

Daily Attendance
1 0.9 0.8 0.7 0.6 0.5 0.4 0.3 0.2 0.1 0 Monday Tuesday Wednesday Thursday Friday Saturday Sunday Accounts HR Lobby/Reception Administration Customer Support Finance Human Resources IT Marketing R&D Sales

Time Table Settings
Code SICK PH H OFF L OP 6 OP 7 OP 8 OP 9 OP 10 Name Sick Public Holidays Holidays Off Lieu Day Option 6 Option 7 Option 8 Option 9 Option 10 Paid Hours 00.00 08.00 08.00 00.00 08.00 00.00 00.00 00.00 00.00 00.00 Name of the Department Accounts HR Lobby/Reception Administration Customer Support Finance Human Resources IT Marketing R&D Sales

END-USER LICENSE AGREEMENT
For more timesheet templates visit: Spreadsheet123.com

© 2009 Spreadsheet123.com.All rights reserved IMPORTANT—READ CAREFULLY: This End-User License Agreement (”EULA”) is a legal agreement between you and Spreadsheet123.com that covers all Microsoft Excel and OpenOffice.org templates or spreadsheets (”TEMPLATES”) made by Spreadsheet123.com. By downloading, copying, accessing or otherwise using any TEMPLATES, you agree to be bound by the terms of this EULA. TEMPLATES LICENSE This TEMPLATE is protected by copyright laws and international copyright treaties, as well as other intellectual property laws and treaties. Each TEMPLATE is licensed, not sold. 1. GRANT OF LICENSE. This EULA grants you the right to download the TEMPLATES free of charge for personal use or for your company use. You may customize this Time Table Template with you personal or company information and use it for your business requirements and with your employees but you may not remove or alter any logo, trademark, copyright, hyperlinks, disclaimers, terms of use or other proprietary notices within the TEMPLATES. You may not sell, resell, license, rent, lease, lend, or place on the public server (Internet) or otherwise transfer for value without written permission of SPREADSHEET123.COM 2. TERMINATION. Without prejudice to any other rights, Spreadsheet123.com may terminate this EULA if you fail to comply with the terms and conditions of this EULA. In such event, you must destroy all copies of any TEMPLATE. 3. NOTICE SPECIFIC TO TEMPLATES. SPREADSHEET123.COM MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY OF THE TEMPLATES FOR ANY PURPOSE. ALL TEMPLATES ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND. SPREADSHEET123.COM HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THE TEMPLATES, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT. IN NO EVENT SHALL SPREADSHEET123.COM BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS 4. MISCELLANEOUS. Some states do not allow the limitation or exclusion of liability for incidental or consequential damages, so the above limitation may not apply to you.


				
DOCUMENT INFO
Description: Weekly time table template or also known as a weekly staff rota that helps to quickly produce your staff rota and save minimum two hours a week. There are a few programs on the internet that can produce weekly staff time table automatically. However , most of this staff rota or staff time table programs are either really expensive or very complicated to use. Spreadsheet123 has set up a weekly rota for you in Microsoft Excel. This weekly staff time table in excel is very easy to use and edit to meet requirements of your business. The work time table template that we have created calculates the amount of hours for each staff member as for a shift as well as for entire week. The rota templates also calculates your weekly labour cost and allowing you to create a simple weekly payroll budget. Time table template is equipped with HR dashboards that can help to organise your staff rotation and to control your weekly payroll budget and salary distribution and also has an integrated time card template in order to be printed for all of the employees individually.
BUY THIS DOCUMENT NOW PRICE: $14.95 100% MONEY BACK GUARANTEED
PARTNER Spreadsheet123 Ltd
Spreadsheet123 is your ultimate guide to the world of Excel. Every template that you could need for business, real estate, budgeting, personal and corporate finance can be found on this site. In addition, there are Excel calculators, tutorials and links. Visit www.spreadsheet123.com for all of your spreadsheet needs.