Fill in these first
- Business and roles: [e.g. cafe with baristas and counter staff, or a support desk with agents]
- Opening hours by day: [e.g. Mon-Sat 8:00-22:00, Sun 9:00-21:00]
- Demand data: [hourly customers, orders, tickets or calls, ideally four weeks or more]
- Capacity of one person per hour: [e.g. a barista handles 25 orders an hour, an agent 6 tickets]
- Shift rules: [minimum and maximum shift length, break rules, minimum staff on the floor]
- Current team size and contracted hours: [count and hours per person]
Task
Work out how many people each role needs in each hour, then build shifts that match that need with as little idle time as possible.
Output format
- | Hour | Mon | Tue | Wed | Thu | Fri | Sat | Sun | (average demand per hour)
- Same table showing staff needed: demand divided by capacity, rounded up, never below the floor minimum.
- Shift plan per day: | Role | Shift start | Shift end | Break | Count |
- Total staffed hours against contracted hours, and the gap.
- Hours still under or over staffed after the plan, with the reason.
Rules
- Use averages from the pasted data and say how many weeks they come from.
- Flag days affected by holidays or one-off events and leave them out of the averages.
- Add a 10-15% buffer only if the data shows large swings within an hour, and state it.
- Keep every shift inside the stated legal and contract limits.
Example
Saturday 13:00-15:00 averages 62 orders an hour; at 25 per barista that needs 3 baristas, so a 12:00-20:00 shift covers the lunch peak and the evening rush.






