How to Build a Retail Staff Rota Around Footfall

How do you build a retail rota around footfall, step by step?

The short version is seven steps. Each takes minutes once the data is in one place, and the first time through takes about an afternoon.

• 1. Export four normal weeks of footfall (from a people counter) and net sales by hour (from your till), and average them by weekday and hour.
• 2. Set a minimum cover for every open hour, for safety and basic service.
• 3. Set a service ratio: how many customers one person can serve well in an hour in your store.
• 4. Calculate staff needed per hour: the larger of the minimum and footfall divided by the service ratio, rounded up.
• 5. Turn your labour budget into affordable hours, then take out off-floor hours and minimum cover to see how many hours you can place.
• 6. Build the rota peaks first, then the shoulders, openings and closings, quiet hours and off-floor time.
• 7. Check cover hour by hour, key-holders, skills, breaks, rest, contracts, fairness and local rules, then publish to a fixed standard and log every change.

What data do you need to schedule staff by footfall?

You need two numbers for every trading hour: how many people came in and how much they spent. Footfall usually comes from a people counter over the door, a beam or camera unit that your shopping centre or till provider may already supply. Net sales by hour come from the hourly report in your point-of-sale system. Use sales without VAT, GST or sales tax so the numbers compare cleanly over time.

Average four normal weeks, separately for each weekday, and leave out sale days, closures and public holidays, because one strange day distorts an average of four. If you have no counter, ask a colleague to tally visitors with a hand clicker for one representative week. Rough numbers that show the shape of each day are far better than none.

When you compare with last year, compare like weekdays. A retail calendar such as the 4-5-4 calendar published by the US National Retail Federation exists for exactly this reason: it keeps periods starting on the same weekday so a Saturday is compared with a Saturday.

How many staff does a shop need per hour?

Footfall becomes people through a service ratio. There is no universal figure: a fashion store with a fitting room might serve 15 to 25 customers per person per hour, a convenience store far more on the floor with the till as the real limit, and an electronics store with long demonstrations far fewer. Start from your best-run hours, the ones where the team was busy but nobody waited, and divide that hour's footfall by the people on the floor.

Then apply a minimum, typically two in a small store, set by your own risk assessment. Staff needed in any hour is the larger of the minimum and footfall divided by the ratio, rounded up. Add people for jobs that are not on the floor, such as deliveries, office time and training, on top.

How do you turn a labour budget into rota hours?

Most stores set a labour budget as a percentage of net sales. The right figure depends on your sector, prices and service model, so the useful number is your own or the one your owner sets, not a benchmark copied from elsewhere. To turn it into hours you need the week's sales forecast and your average hourly cost including employer on-costs such as pension contributions and payroll taxes, because pay alone understates it.

Here is a worked example for a small fashion store open 60 hours a week with a minimum of two people on the floor. Every figure is illustrative; use your own.

• Read the result as 'about 72 hours to put where customers are', not as a target to spend.
• Managers cost more per hour, so a rota can be under budget in hours and over budget in money. Check planned cost, not just hours.
• Sales per labour hour (net sales / paid hours) is the other side of the same coin: read it next to conversion, never alone.

How do you keep a retail rota fair and legal?

Fair means the same rules for everyone and the unpopular shifts shared over time. Count Saturdays, Sundays, closes and early starts per person over each four-week period, handle requests in a known order, respect contracted and maximum hours and personal limits such as students' term-time hours, and never use the rota to reward or punish.

Legal depends on where you are, and the differences are large. In the UK, workers over 18 are usually entitled to an uninterrupted 20-minute break when they work more than six hours a day and 11 hours' rest between working days, according to GOV.UK. Australia's General Retail Industry Award 2020 sets rest and meal breaks by hours worked and a 12-hour break between shifts that can be reduced to 10 by agreement. Singapore's Ministry of Manpower says covered employees should generally not work more than six consecutive hours without a break.

Some places also regulate notice. New York City's Fair Workweek law requires covered retail employers to give schedules at least 72 hours in advance and bans on-call shifts, according to the city's Department of Consumer and Worker Protection. Oregon requires covered retail, hospitality and food service employers with 500 or more employees worldwide to give written schedules 14 days ahead, according to the state's Bureau of Labor and Industries. Rules change, so check the official source for your location, your HR adviser and local law before relying on any summary.

Does a stable, predictable rota affect sales?

There is evidence that it can. In a randomised experiment across 28 Gap stores in the San Francisco and Chicago areas, reported in 2018 by researchers from the Center for WorkLife Law, the University of Chicago and UNC Kenan-Flagler Business School, stores that made schedules more stable saw median sales rise by 7% and labour productivity by 5%. One study in one retailer cannot predict what happens in your store, but it is a good reason to treat schedule stability as a business tool rather than a cost.

In practice, stability means publishing to a fixed standard (two weeks ahead is common), building regular patterns where demand allows, logging every change after publishing with its reason, and handling swaps and absence the same way every time.

How should you staff peak and sale days?

A peak day has the same shape as a normal busy Saturday, only taller, and the pinch points are almost always the till queue and the fitting room or demonstration area. Plan those first, two to three weeks ahead, so the rota can still be published to your normal standard.

Start from last year's same day and this year's trend, then estimate the busiest hour: footfall times conversion gives transactions, and transactions divided by how many one till can serve in an hour gives the tills you need. Add floor and fitting room cover from your service ratio. Agree any extra hours with your owner before you publish, and offer them fairly, starting with people who have asked for more.

Breaks need more planning on a peak day, not less. Put them before and after the peak, write them on a plan the team can see, and make sure nobody works through a break because it is busy. Decide in advance the queue length that opens a second till and who opens it. The next morning, spend fifteen minutes comparing plan with actual and write down what to repeat next year.

• Plan the queue and the fitting room first, then everything else.
• No breaks in the busiest hour; breaks written down before opening.
• A named lead for the till, fitting room, floor and stock.
• A queue trigger (for example four people) and a named person to open the next till.
• An after-action review the next morning, kept for next year.

What are the most common rota mistakes?

• Copying last year's rota, which staffs the shop you used to be rather than the one you are.
• Spreading hours evenly across the day instead of placing them where customers are.
• Cutting the busiest hours to meet the budget, when quiet over-covered hours should go first.
• Planning breaks on the floor at lunchtime instead of on paper before opening, outside the peak.
• Forgetting a key-holder at opening or closing, or a skill such as refunds or the safe.
• Publishing late and changing published shifts casually.
• Letting software or an AI assistant publish a rota nobody has checked for fairness and the law.

How do you know the rota is working?

Read a few numbers together every week: footfall, conversion (transactions divided by footfall), average transaction value, units per transaction, sales per labour hour and labour cost as a share of sales. If footfall is steady and conversion rises while paid hours stay flat, the hours are in better places. If sales per labour hour rises but conversion falls, the floor may be too thin. Watch the human signals too: missed breaks, the same few people always covering, and rising short-notice absence.

If you want a ready-made set of files for this, The Retail Staff Rota and Daily Sales Kit from Bodhih Training includes a workbook that calculates staff needed per hour, checks a rota hour by hour against need and budget, and tracks these numbers daily. Managers who want to test their own scheduling judgement can try AssessAll's Workforce Planning and Scheduling Assessment, and Jobulary's guide to a development plan that survives week six helps turn what you learn into lasting habits for supervisors.