Pro package
Weekly Shift Schedule & Hours Planner
Staff list, availability, a weekly rota with paid hours and cost per shift, and labour % vs forecast sales.
Excel · SheetsStaff list, availability, a weekly rota with paid hours and cost per shift, and labour % vs forecast sales.
What's included:
- Staff list with rates and maximum hours
- Availability with clash flags on the rota
- Paid hours with breaks and overnight shifts
- Cost per shift including employer extras
- Hours and cost by day; labour % vs target
- Excel, Google Sheets and LibreOffice
Preview: what's inside
Settings Settings
| Setting | Value |
|---|---|
| Week starting | 2026-11-16 |
| Target labour cost % | 28% |
| Forecast sales for the week | 18,500.00 |
| Employer extras on wages (tax, holiday, etc.) | 12% |
Summary Week summary
- Scheduled paid hours
- Labour cost incl. employer extras
- Labour cost % of forecast sales
- Budget left at target %
- People over their max hours
- Shifts on unavailable days
Sheet Staff — One row per person.
| Name | Role | Hourly rate | Max hours / week | Scheduled hours | Over max? | Phone |
|---|---|---|---|---|---|---|
| Sam | Supervisor | 19.50 | 40 | auto | auto | |
| Priya | Kitchen | 17.00 | 38 | auto | auto | |
| Leo | Front of house | 15.50 | 24 | auto | auto |
Sheet Availability — Days people can't or prefer not to work this week.
| Name | Day | Availability | Note | Key |
|---|---|---|---|---|
| Leo | Tue | Unavailable | College | auto |
| Ines | Sun | Prefer not | auto |
Sheet Rota — One row per shift. 24-hour decimal times.
| Day | Name | Role | Start | End | Unpaid break (min) | Paid hours | Shift cost | Clash? | Note |
|---|---|---|---|---|---|---|---|---|---|
| Mon | Sam | Supervisor | 9 | 17.5 | 30 | auto | auto | auto | |
| Mon | Priya | Kitchen | 10 | 18 | 30 | auto | auto | auto | |
| Tue | Leo | Front of house | 17 | 22 | auto | auto | auto |
Sheet By day — Hours and cost per day.
| Day | Shifts | Hours | Cost |
|---|---|---|---|
| Mon | auto | auto | auto |
| Tue | auto | auto | auto |
| Wed | auto | auto | auto |
Preview generated from the actual file: sample rows are example data you replace with your own; formulas fill the calculated columns.
Good to know
- Instant digital download. Nothing physical is shipped.
- Licensed for personal and single-business use.
- 30-day fix-or-refund if a file doesn't work as described (terms).
- Support: eclipsekingdom.support@gmail.com