wowprompt

Staff shift planning from hourly footfall or order data

Reads hourly customer or order counts by weekday and turns them into a staffing plan with the number of people needed per hour and shift times that cover the peaks. Use it for a shop, salon, cafe or support desk where some hours are packed and others are idle.

An hour-by-weekday table of average demand and staff needed, a shift plan with start and end times per role, and the hours that stay under or over staffed
The output this prompt produced, unedited.

The prompt

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

  1. | Hour | Mon | Tue | Wed | Thu | Fri | Sat | Sun | (average demand per hour)
  2. Same table showing staff needed: demand divided by capacity, rounded up, never below the floor minimum.
  3. Shift plan per day: | Role | Shift start | Shift end | Break | Count |
  4. Total staffed hours against contracted hours, and the gap.
  5. 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.

staff schedulingshift planningfootfall analysisstaffing by hourretail roster planningpeak hour staffing

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity