Staff Scheduling by PrestigeLegalDoc

VIEWS: 322 PAGES: 11

More Info
									                                           GUIDELINES

    GENERAL

    Definition: A vacation tracking spreadsheet is used by managers to track vacation time
    balances for employees during the calendar and/or fiscal year.

    Objective: The purpose of a vacation tracking spreadsheet is to properly document vacation
    time taken for each employee, as well as to keep an updated calculation for remaining unused
    vacation time by employee and overall. Managers will utilize this spreadsheet to manage

    The Spreadsheet:
    The spreadsheet contains a weekly work schedule for a 24-hour establishment. Time slots may
    be deleted dependent upon the actual hours employees need to be staffed during any given day.
    To see an example of how the spreadsheet will look when it is completed, click on the

    Procedure to complete the spreadsheet:
    1. Enter the last day of the week (Saturday's date) at the top of "Weekly Employee Summary"
    tab. The dates listed in the daily tabs will automatically adjust. The "Weekly Employee
    Summary" tab can also be used to tally the weekly total hours per employee and total hours
    worked by all employees for the week. To do this, replace the "Employee" entries with the
    actual each daily name and enter the total hours scheduled given day with the names of the
    2. On employee tab, replace the "Employee" entries for a for the week.
    employees that will be scheduled to work. You may include emloyees not scheduled as well to
    show that they are not working any hours that day. Each day is separated into three shifts with an
    hour overlap in order to "change"enter whatever information is easiest for your business.
    3. Under each hour slot, you can shifts between employees.
    Whether you enter an "x" or the position of the person working, the totals will tally for hours
    worked per hour as well at the end of the columns for per employee totals. A sum of all hours
    scheduled per day will total at the end of each employee's daily total. Enter any unpaid breaks
    4. Each hour on the spreadsheet represents the start of the work hour. For example, an "x" under
    7 AM signifies that the employee is scheduled to work from 7 to 8 AM. If their shift ends at 1
    PM, an "x" would not be input under the 1 PM slot. The 1 PM slot is for those working from 1
    PM to 2 PM.




© Copyright 2011 Docstoc Inc.
© Copyright 2011 Docstoc Inc.
   Work Schedule for Week Ending
        November 26, 2011
                Total Hours
      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Employee                  0.00

      Weekly Hours Total        0.00




© Copyright 2011 Docstoc Inc.
     November 20, 2011

                                                                                    1ST SHIFT
The first employee listed should                                                                                                                           Unpaid   TOTAL hours
                                   7:00 A.M.   8:00 A.M.   9:00 A.M. 10:00 A.M. 11:00 A.M. 12:00 P.M. 1:00 P.M.        2:00 P.M.   3:00 P.M.   4:00 P.M.
be the manager on duty                                                                                                                                     Break?     worked
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
HeadcountTotal                         0          0           0           0           0           0           0           0           0           0                    0.00

                                                                                    2ND SHIFT
The first employee listed should                                                                                                                           Unpaid   TOTAL hours
                                   3:00 P.M.   4:00 P.M.   5:00 P.M.   6:00 P.M.   7:00 P.M.   8:00 P.M.   9:00 P.M. 10:00 P.M. 11:00 P.M. 12:00 A.M.
be the manager on duty                                                                                                                                     Break?     worked
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
HeadcountTotal                         0          0           0           0           0           0           0           0           0           0                    0.00

                                                                                    3RD SHIFT
The first employee listed should                                                                                                                           Unpaid   TOTAL hours
                                   11:00 P.M. 12:00 A.M. 1:00 A.M.     2:00 A.M.   3:00 A.M.   4:00 A.M.   5:00 A.M.   6:00 A.M.   7:00 A.M.   8:00 A.M.
be the manager on duty                                                                                                                                     Break?     worked
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
Employee                                                                                                                                                               0.00
HeadcountTot
								
To top