EMPLOYEE SCHEDULE W HOURLY TOTALS AND PROJECTED STAFF GRAPH

Document Sample
EMPLOYEE SCHEDULE W HOURLY TOTALS AND PROJECTED STAFF GRAPH Powered By Docstoc
					                                                                                             Employee Schedule                                                      Week 1
                      MONDAY                    TUESDAY                  WEDNESDAY                   THURSDAY                          FRIDAY                SATURDAY                      SUNDAY
          Date       11/30/2009                 12/1/2009                 12/2/2009                   12/3/2009                       12/4/2009               12/5/2009                    12/6/2009         WEEK    O.T.

     Time           In        Out              In        Out              In        Out              In        Out               In        Out              In        Out             In        Out          TOTAL
1ST SHIFT
Dave             7:00 AM    9:00 AM    2                          0    7:30 AM    9:30 AM    2    3:00 PM    7:00 PM    4     8:00 AM    10:00 AM   2                          0                              10
                                                                                                                                                                                                        0
Joe                                    0                          0    5:00 PM    8:00 PM    3                          0                           0                          0                               3
                                                                                                                                                                                                        0
Leslie                                 0                          0                          0                          0                           0                          0                               0
                                                                                                                                                                                                        0
Michael                                0    11:00 AM   2:00 PM    3                          0    12:00 PM   3:00 PM    3     10:00 AM    1:00 PM   3     9:00 AM   3:00 PM    6                              15
                                                                                                                                                                                                        0
Inez                                   0                          0                          0    7:00 AM    1:00 PM    6                           0                          0    7:00 AM   2:00 PM         13
                                                                                                                                                                                                        7
Aricka                                 0    8:00 AM    2:00 PM    6    8:00 AM    1:00 PM    5    8:00 AM    12:00 PM   4                           0                          0                              15
                                                                                                                                                                                                        0
Latika                                 0    8:30 AM    12:00 PM 3.5    8:30 AM    12:00 PM 3.5    8:30 AM    1:00 PM    4.5   8:30 AM     3:00 PM   6.5                        0                              18
                                                                                                                                                                                                        0
Chris            7:00 AM    3:00 PM    8    8:00 AM    4:00 PM    8    7:00 AM    3:00 PM    8    11:00 AM   6:00 PM    7     1:00 PM     6:00 PM   5                          0    9:00 AM   1:00 PM         40
                                                                                                                                                                                                        4
Eric             8:00 AM    2:00 PM    6    7:00 AM    11:00 AM   4                          0                          0     7:00 AM     1:00 PM   6     8:00 AM   2:00 PM    6    7:00 AM   3:00 PM         30
                                                                                                                                                                                                        8
Jonathan         7:30 AM    2:00 PM    6.5 12:00 PM    7:00 PM    7    12:00 PM   7:00 PM    7    7:00 AM    9:00 AM    2                           0     7:00 AM   3:00 PM    8                              30.5
                                                                                                                                                                                                        0
Jordan                                 0                          0                          0    5:00 PM    7:00 PM    2                           0                          0                               2
                                                                                                                                                                                                        0
2ND SHIFT
Kimberly                               0                          0    1:00 PM    9:00 PM    8    12:00 PM   8:00 PM    8     3:00 PM     8:00 PM   5     2:00 PM   9:00 PM    7    1:00 PM   9:00 PM         36
                                                                                                                                                                                                        8
Samantha         4:00 PM    10:00 PM   6    2:00 PM    10:00 PM   8    1:00 PM    7:00 PM    6    3:00 PM    10:00 PM   7     1:00 PM     7:00 PM   6                          0                              33
                                                                                                                                                                                                        0
Lucy             4:00 PM    11:00 PM   7    5:00 PM    11:00 PM   6                          0    4:00 PM    11:00 PM   7                           0     3:00 PM   10:00 PM   7    3:00 PM   9:00 PM         33
                                                                                                                                                                                                        6
Carol            2:00 PM    9:00 PM    7                          0    4:00 PM    11:00 PM   7                          0     1:00 PM     9:00 PM   8                          0                              22
                                                                                                                                                                                                        0
Kristin                                0    6:30 PM    10:00 PM 3.5    6:30 PM    10:00 PM 3.5                          0     6:30 PM     9:00 PM   2.5                        0                              9.5
                                                                                                                                                                                                        0
Shawn            5:00 PM    8:00 PM    3    4:00 PM    8:00 PM    4                          0                          0                           0     3:00 PM   7:00 PM    4                              11
                                                                                                                                                                                                        0
3RD SHIFT
Ann              11:00 PM   9:00 AM    10   11:00 PM   9:00 AM    10   11:00 PM   9:00 AM    10   11:00 PM   9:00 AM    10                          0                          0                              40
                                                                                                                                                                                                        0
Susan                                  0                          0                          0                          0     9:00 PM     7:00 AM   10    9:00 PM   7:00 AM    10   9:00 PM   8:00 AM         31
                                                                                                                                                                                                        11
GM
Nicole           9:00 AM    5:00 PM    8    9:00 AM    5:00 PM    8    9:00 AM    5:00 PM    8    9:00 AM    5:00 PM    8     9:00 AM     5:00 PM   8                          0                              40
                                                                                                                                                                                                        0
  TOTAL
                                       64                         71                         71                         73                          62                         48                       44    432     0
  HOURS
                                                                                  Employee Schedule                                                           Week 2
                          MONDAY                     TUESDAY             WEDNESDAY                   THURSDAY                     FRIDAY               SATURDAY                     SUNDAY
           Date           11/9/2009              11/10/2009                11/11/2009                11/12/2009                11/13/2009               11/14/2009              11/15/2009            WEEK    O.T.    P.R.
       Time          In        Out              In       Out              In       Out              In       Out             In       Out             In       Out             In       Out           TOTAL          TOTAL
1ST SHIFT
Dave                                    0                         0                         0                         0                        0                        0                                             10
                                                                                                                                                                                                 0      0
Joe                                     0                         0                         0                         0                        0                        0                                              3
                                                                                                                                                                                                 0      0
Leslie                                  0                         0                         0                         0                        0                        0                                              0
                                                                                                                                                                                                 0      0
Michael                                 0                         0                         0                         0                        0                        0                                             15
                                                                                                                                                                                                 0      0
Inez                                    0                         0                         0                         0                        0                        0                                             13
                                                                                                                                                                                                 0      0
Aricka                                  0                         0                         0                         0                        0                        0                                             15
                                                                                                                                                                                                 0      0
Latika                                  0                         0                         0                         0                        0                        0                                             18
                                                                                                                                                                                                 0      0
Chris                                   0                         0                         0                         0                        0                        0                                             40
                                                                                                                                                                                                 0      0
Eric                                    0                         0                         0                         0                        0                        0                                             30
                                                                                                                                                                                                 0      0
Jonathan                                0                         0                         0                         0                        0                        0                                             30.5
                                                                                                                                                                                                 0      0
Jordan                                  0                         0                         0                         0                        0                        0                                              2
                                                                                                                                                                                                 0      0
2ND SHIFT
Kimberly                                0                         0                         0                         0                        0                        0                                             36
                                                                                                                                                                                                 0      0
Samantha                                0                         0                         0                         0                        0                        0                                             33
                                                                                                                                                                                                 0      0
Lucy                                    0                         0                         0                         0                        0                        0                                             33
                                                                                                                                                                                                 0      0

Carol                                   0                         0                         0                         0                        0                        0                                             22
                                                                                                                                                                                                 0      0
Kristin                                 0                         0                         0                         0                        0                        0                                             9.5
                                                                                                                                                                                                 0      0
Shawn                                   0                         0                         0                         0                        0                        0                                             11
                                                                                                                                                                                                 0      0
3RD SHIFT
Ann               11:00 PM    9:00 AM   10   11:00 PM   9:00 AM   10   11:00 PM   9:00 AM   10   11:00 PM   9:00 AM   10                       0                        0                                             80
                                                                                                                                                                                                 0     40
Susan                                   0                         0                         0                         0    9:00 PM   7:00 AM   10   9:00 PM   7:00 AM   10   9:00 PM   8:00 AM                        62
                                                                                                                                                                                                 11    31
GM

Nicole            9:00 AM     5:00 PM   8    9:00 AM    5:00 PM   8    9:00 AM    5:00 PM   8    9:00 AM    5:00 PM   8    9:00 AM   5:00 PM   8                        0                                             80
                                                                                                                                                                                                 0     40
   TOTAL
                                        18                        18                        18                        18                       18                       10                       11    111     0      543
   HOURS
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole
          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM
       Monday




6 PM   7 PM   8 PM   9 PM   10 PM 11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole


          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM
       Tuesday




6 PM   7 PM   8 PM   9 PM   10 PM 11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
                                                                                             Wednesday
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole


          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM   7 PM   8 PM   9 PM   10 PM 11 PM
11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
                                                                                             Thursday
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole


          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM   7 PM   8 PM   9 PM   10 PM 11 PM
11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
                                                                                             Friday
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole


          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM   7 PM   8 PM   9 PM   10 PM 11 PM
11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
                                                                                             Saturday
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole


          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM   7 PM   8 PM   9 PM   10 PM 11 PM
11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
                                                                                             Sunday
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole


          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM   7 PM   8 PM   9 PM   10 PM 11 PM
11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
                                                                                             MONDAY
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole
          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM   7 PM   8 PM   9 PM   10 PM 11 PM
11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
                                                                                             TUESDAY
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole
          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM   7 PM   8 PM   9 PM   10 PM 11 PM
11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
                                                                                             WEDNESDAY
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole
          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM   7 PM   8 PM   9 PM   10 PM 11 PM
11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
                                                                                             THURSDAY
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole
          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM   7 PM   8 PM   9 PM   10 PM 11 PM
11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole
          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM
       FRIDAY




6 PM   7 PM   8 PM   9 PM   10 PM 11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
                                                                                             SATURDAY
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole
          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM   7 PM   8 PM   9 PM   10 PM 11 PM
11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM
      Dave
        Joe
     Leslie
  Michael
       Inez
    Aricka
    Latika
      Chris
        Eric
 Jonathan
   Jordan
2ND SHIFT
 Kimberly
Samantha
      Lucy
     Carol
    Kristin
   Shawn
3RD SHIFT
       Ann
    Susan
        GM
    Nicole
          7 AM   8 AM   9 AM   10 AM 11 AM 12 PM   1 PM   2 PM   3 PM   4 PM   5 PM   6 PM
       SUNDAY




6 PM   7 PM   8 PM   9 PM   10 PM 11 PM 12 AM   1 AM   2 AM   3 AM   4 AM   5 AM   6 AM   7 AM

				
DOCUMENT INFO
Description: AN EXCEL 2007 SCHEDULE TEMPLATE FOR BI-WEEKLY PAY PERIODS. THE SCHEDULE IS DIVIDED UP BY WEEK INTO 2 WORKSHEETS. ALL YOU DO IS PUT IN THE START AND END TIMES PER EMPLOYEE SHIFT PER DAY AND IT CALCULATES THE REST. IT WILL GIVE YOU # OF HOURS PER EMPLOYEE SHIFT, DAILY LABOR TOTALS, WEEKLY HOUR TOTALS PER EMPLOYEE, WEEKLY OVERTIME TOTALS PER EMPLOYEE, WEEKLY LABOR TOTALS, WEEKLY OVERTIME LABOR TOTALS, AND TOTAL PAYROLL HOURS. IT ALSO INCLUDES TABS THAT CALCULATE A PROJECTED STAFFING GRAPH FOR EACH DAY SO THAT YOU CAN VISUALLY SEE HOW MANY EMPLOYEES YOU HAVE SCHEDULED PER HOUR. PLEASE LET ME KNOW IF YOU FIND IT USEFUL, OR WHAT ADDITIONS YOU MAY HAVE MADE TO IT TO FIT YOUR NEEDS.