Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Authentication
digital resources
240x Filetype XLSX File size 0.03 MB Source: images.template.net
Sheet 1: Schedule
| Weekly Employee Shift Schedule [Company Name] |
|||||||||
| Period Start Date : | Friday, December 12, 2008 | ||||||||
| Fri | Sat | Sun | Mon | Tue | Wed | Thu | Paid | Total | |
| Employee | 12-Dec-08 | 13-Dec-08 | 14-Dec-08 | 15-Dec-08 | 16-Dec-08 | 17-Dec-08 | 18-Dec-08 | Hours | Labor Cost |
| Employee 1 | Day Shift | Day Shift | Swing Shift | Swing Shift | Night Shift | 40.0 | $600.00 | ||
| Employee 2 | Vacation | Shift A | Shift C | Shift D | 20.0 | $320.00 | |||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| 0.0 | $0.00 | ||||||||
| Total Paid Hours | 0.0 | 0.0 | 16.0 | 12.0 | 12.0 | 12.0 | 8.0 | 60.0 | |
| Daily Labor Cost | $0.00 | $0.00 | $248.00 | $184.00 | $184.00 | $184.00 | $120.00 | $920.00 | |
| Notes: | |||||||||
| 1) This template worksheet is protected to prevent accidental deletion of the underlying formulas. The password used is "password" | |||||||||
| 2) Using this workbook, you can create a weekly work schedule for up to 20 employees and 9 shifts. Employee names and labor rates are defined in the Employees worksheet. Shifts and shift durations are defined in the Shifts worksheet. To assign a shift to an employee, click on the corresponding schedule cell and pick a shift from the drop-down list. Work hours and labor costs are automatically computed based on shift assignments and labor rates. If your scheduling needs are more than just creating a weekly work schedule, you should use a scheduling program like Snap Schedule (http://www.BMScentral.com). | |||||||||
| Click here for more information on Snap Schedule Employee Scheduling Software | |||||||||
| Copyright © 2008-2009 Business Management Systems, Inc. All Rights Reserved. | |||||||||
| Shift | Starts | Ends | Paid Hrs |
| Day Shift | 7:00AM | 3:00PM | 8 |
| Swing Shift | 3:00PM | 11:00PM | 8 |
| Night Shift | 11:00PM | 7:00AM | 8 |
| Shift A | 7:00AM | 11:00AM | 4 |
| Shift B | 11:00AM | 3:00PM | 4 |
| Shift C | 3:00PM | 7:00PM | 4 |
| Shift D | 7:00PM | 11:00PM | 4 |
| Shift E | 11:00PM | 3:00AM | 4 |
| Vacation | 3:00AM | 7:00AM | 8 |
| Notes: | |||
| 1) Change shift start times, end times, and payable work hours as needed to match your operations. | |||
| 2) If you change the shift description or colors, you must manually update the affected shift assignments in the Schedule worksheet |
no reviews yet
Please Login to review.
