scheduling_example.xlsx
Scheduling
| Eight-hour rate | $9 | per hour |
| Four-hour rate | $8.50 | per hour |
| OH Cost/employee | $5 | per day |
| | number | number |
| | starting | starting | Actual | Minimum |
| | 8-hr shift | 4-hr shift | staff size | staff size |
| Day 1, Interval 1 | | | 0 | 3 |
| Day 1, Interval 2 | | | 0 | 10 |
| Day 1, Interval 3 | | | 0 | 15 |
| Day 1, Interval 4 | | | 0 | 20 |
| Day 1, Interval 5 | | | 0 | 17 |
| Day 1, Interval 6 | | | 0 | 7 |
| Day 2, Interval 1 | | | 0 | 2 |
| Day 2, Interval 2 | | | 0 | 12 |
| Day 2, Interval 3 | | | 0 | 16 |
| Day 2, Interval 4 | | | 0 | 21 |
| Day 2, Interval 5 | | | 0 | 14 |
| Day 2, Interval 6 | | | 0 | 10 |
| cost/person/shift | $77 | $39 |
| Total Cost | $0 |
jesmlshiawlrley
