Why scheduling eats owner time
Scheduling is a puzzle with moving pieces: who's available, who can open, who's close to overtime, who asked for Saturday off, and the week the busy season starts. The puzzle isn't hard. Solving it again every week is the time sink. AI can do the first draft in seconds, if you give it the pieces clearly.
Step 1: set up the spreadsheet
Make three tabs, using Google Sheets or Excel:
- Staff: name, role or skills (opener, closer, barista, driver, lead), maximum hours, minimum hours, and any minor or certification flags.
- Availability: each person's available times this week, and approved time off.
- Shifts needed: each day, the shifts and how many people with which skills.
Update availability each week. The other tabs rarely change.
Step 2: the scheduling prompt
Here's my staff list, availability and shifts needed for the week of [date] (first names only): [paste the three tabs]. Build a schedule as a table, days across and shifts down. Rules: nobody works outside their availability; respect max and min hours; every shift has at least one [opener/lead]; no one closes and then opens the next day; spread weekend shifts fairly. Then list any shifts you couldn't fill, and anyone over or under their hours.
[Name] just called out for [shift]. From this week's schedule and availability, list who could cover it without going over their max hours, best option first.
Next week is [event or season]. Here's last week's schedule. Add [number] people to [days and times] and tell me whose hours that affects.
Step 3: check it before you post
- Count hours yourself. AI can miscount, especially across long tables.
- Overtime: check federal and state overtime rules for anyone near the limit.
- Breaks and minors: meal and rest break rules, and limits on hours for workers under 18, vary by state.
- Predictable scheduling laws: some states and cities, including Oregon and New York City, have rules on how far in advance schedules must be posted and what happens when they change. Check whether they apply to your business.
- Fairness: look at who got the weekends and the best shifts. People notice.
When to move to scheduling software
The spreadsheet-and-prompt method works well for small, fairly stable teams. Consider dedicated scheduling software when:
- Shift swaps and call-outs happen every week and you're managing them by text.
- You need time clocks, labor-cost tracking or payroll connected to the schedule.
- You run more than one location, or have more than about 15 people.
- Staff want to see and trade shifts on their phones.
Well-known options include Homebase, When I Work and 7shifts, and many point-of-sale and payroll systems include scheduling. Check your point-of-sale or payroll provider first, since you may already have it.
Cautions
- Use first names only in AI tools, and keep personal reasons for time off (health, family) out of prompts.
- The schedule is your decision. AI drafts, you approve.
- Post schedules where everyone can see them, with enough notice for your local rules.
Scheduling is often bundled with hiring, training and payroll in the owner's head. Your business's AI plan separates them, and shows which ones are worth handing to AI or software first for your kind of business.