Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Authentication
digital resources
450x Filetype XLSX File size 0.10 MB Source: www.excelsizeyeter.com
Sheet 1: Schedule
| 2-2 3-2 2-3 Rotating Shift Schedule [Company Name] |
||||||||||||||||||||||||||||||
| Period Start Date : | Monday, January 04, 2010 | |||||||||||||||||||||||||||||
| Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Paid | Total | |
| Team | 1/4 | 1/5 | 1/6 | 1/7 | 1/8 | 1/9 | 1/10 | 1/11 | 1/12 | 1/13 | 1/14 | 1/15 | 1/16 | 1/17 | 1/18 | 1/19 | 1/20 | 1/21 | 1/22 | 1/23 | 1/24 | 1/25 | 1/26 | 1/27 | 1/28 | 1/29 | 1/30 | 1/31 | Hours | Labor Cost |
| Team 1 | Day | Day | Day | Day | Day | Day | Day | Night | Night | Night | Night | Night | Night | Night | 840.0 | $14,280.00 | ||||||||||||||
| Team 2 | Night | Night | Night | Night | Night | Night | Night | Day | Day | Day | Day | Day | Day | Day | 840.0 | $18,480.00 | ||||||||||||||
| Team 3 | Night | Night | Day | Day | Day | Day | Day | Day | Day | Night | Night | Night | Night | Night | 840.0 | $22,680.00 | ||||||||||||||
| Team 4 | Day | Day | Night | Night | Night | Night | Night | Night | Night | Day | Day | Day | Day | Day | 840.0 | $26,880.00 | ||||||||||||||
| Total Paid Hours | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 120.0 | 3,360.0 | |
| Daily Labor Cost | $2,340.00 | $2,340.00 | $3,540.00 | $3,540.00 | $2,340.00 | $2,340.00 | $2,340.00 | $3,540.00 | $3,540.00 | $2,340.00 | $2,340.00 | $3,540.00 | $3,540.00 | $3,540.00 | $2,340.00 | $2,340.00 | $3,540.00 | $3,540.00 | $2,340.00 | $2,340.00 | $2,340.00 | $3,540.00 | $3,540.00 | $2,340.00 | $2,340.00 | $3,540.00 | $3,540.00 | $3,540.00 | $82,320.00 | |
| Notes: | ||||||||||||||||||||||||||||||
| 1) This worksheet is protected to prevent accidental deletion of the underlying formulas in summary cells. The password used is "password" | ||||||||||||||||||||||||||||||
| 2) Do not change the shift patterns as they are required to implement the work schedule. Use the Teams worksheet to assign employees to teams. | ||||||||||||||||||||||||||||||
| Shift | Starts | Ends | Paid Hrs |
| Day | 7:00AM | 7:00PM | 12 |
| Night | 7:00PM | 7:00AM | 12 |
| Notes: | |||
| 1) Change shift start times, end times, and payable work hours as needed to match your operations. |
| Employee | Hourly Rate |
| Employee 1 | $15.00 |
| Employee 2 | $16.00 |
| Employee 3 | $17.00 |
| Employee 4 | $18.00 |
| Employee 5 | $19.00 |
| Employee 6 | $20.00 |
| Employee 7 | $21.00 |
| Employee 8 | $22.00 |
| Employee 9 | $23.00 |
| Employee 10 | $24.00 |
| Employee 11 | $25.00 |
| Employee 12 | $26.00 |
| Employee 13 | $27.00 |
| Employee 14 | $28.00 |
| Employee 15 | $29.00 |
| Employee 16 | $30.00 |
| Employee 17 | $31.00 |
| Employee 18 | $32.00 |
| Employee 19 | $33.00 |
| Employee 20 | $34.00 |
| Notes: | |
| 1) Change employee names and hourly rates as needed to reflect your actual data. |
no reviews yet
Please Login to review.
