A filled-in example week
A 60-seat restaurant open for lunch Tuesday to Sunday and dinner Tuesday to Saturday, closed Monday. Times are 24-hour; a shift ending at 00:00 finishes at midnight.
| Employee | Role | Mon | Tue | Wed | Thu | Fri | Sat | Sun |
|---|---|---|---|---|---|---|---|---|
| Rosa | Line cook | off | 10:00-16:00 | 10:00-16:00 | 10:00-16:00 | 15:00-23:00 | 15:00-23:00 | off |
| Dev | Line cook | off | 15:00-22:00 | 15:00-22:00 | 15:00-22:00 | 10:00-16:00 | 10:00-16:00 | 10:00-16:00 |
| Marco | Prep cook | off | 08:00-14:00 | off | 08:00-14:00 | 08:00-14:00 | 08:00-14:00 | off |
| Ana | Server | off | 10:30-15:30 | 16:00-22:00 | 16:00-22:30 | 16:00-23:00 | 16:00-23:00 | 10:30-15:30 |
| Ben | Server | off | 16:00-22:00 | 16:00-22:00 | 10:30-15:30 | 10:30-15:30 | 10:30-15:30 | off |
| Chloe | Server | off | 16:00-22:00 | 10:30-15:30 | 16:00-22:00 | 17:00-23:00 | 17:00-23:00 | 10:30-15:30 |
| Kim | Bartender | off | off | 16:00-23:00 | 16:00-23:00 | 16:00-00:00 | 16:00-00:00 | off |
| Jules | Host | off | off | off | off | 17:00-22:00 | 17:00-22:00 | 10:30-15:00 |
| Sol | Dish / close | off | 17:00-23:00 | off | 17:00-23:00 | 17:00-00:00 | 17:00-00:00 | off |
How the spreadsheet is laid out
- One row per person, grouped into front of house and kitchen, with a position on every row.
- Each day has a start and an end column. Hours are calculated from them, including shifts that end after midnight.
- A weekly hours column, highlighted from 40 hours.
- Below the grid, a count per day of servers and cooks working at 12:30 (lunch peak) and 19:30 (dinner peak), next to the number you need, which you can change.
Building it service by service
- Start with dinner on your two busiest nights. Fill the line first, then servers, then bar, host and dish.
- Do lunch next. A lighter lunch often needs one cook and one or two servers.
- Overlap shifts at changeover. In the example, Friday's dinner servers arrive at 16:00 and 17:00 while the lunch cook is still on until 16:00.
- Put the close on people who aren't opening the next morning. See clopening shifts.
- Check the peak counts against your need. The restaurant staffing by service guide shows how to set those numbers from covers.
After you post it
Someone will call out. Have a plan ready: covering a last-minute call-out. To check what the week costs against sales, use the labor cost percentage calculator.