IMAS Analytics.AI
HomeSolutionsPeople counting & visitor analyticsXPERIO dashboardVisitor forecastingAI building energy managementIndustriesShopping mallsRetail chainsAirports & transport hubsOffice & commercial buildingsTry itProjectsInsightsAbout usPartnersContact us

DATA INTELLIGENCE

Retail Staff Scheduling Based on Real Customer Traffic: Using Visitor Forecasts to Get Shifts Right

Retail staff scheduling is something branch managers do every week, and it directly affects both sales and cost. With too few people at peak times, customers wait and walk out without buying. With too many people when the store is quiet, labour hours are spent without producing sales. This article explains how to schedule shifts from "the actual number of customers entering the store each hour" instead of staffing evenly all day, with a worked example, how to do it in Excel, and the role of a visitor forecasting system.

Store supervisor holding a short briefing with staff on the sales floor before opening

Why Schedule by Customer Traffic, Not by Sales Alone?

Many stores plan shifts from the manager's experience and past sales. That works to a degree, but sales only tell you "how many people bought", not "how many people came in". When many customers enter but there are not enough staff, sales come out lower than they should. If those sales are then used to plan the next roster, the store keeps under-staffing the same period again and again.

Footfall from a people-counting system is therefore a better starting point, because it reflects the "demand for service" that actually occurred, whether or not the visitor bought anything. Read alongside the conversion rate, it shows clearly which hours the store loses opportunities because of too few staff. For how to calculate it, see the article How to calculate conversion rate for a physical store.

Data You Need for Staff Scheduling

Data Where it comes from What it is used for
Hourly store entries over several past weeks People-counting system at the entrance Seeing patterns by day and time
Hourly number of bills and sales Point-of-sale (POS) system Checking conversion rate and finding hours with lost opportunity
Store and venue calendar Marketing team, shopping centre Promotions, events, long weekends, payday
Weather Weather forecast data Rain or hot weather affects mall footfall
Team constraints HR, branch manager Headcount, skills, leave, breaks, legal and company rules

5 Steps to Schedule Shifts from Store Traffic

1. Look at the Footfall Pattern by Day and Hour

Put past footfall into a table of day of the week × time slot. You will see right away that each day has a different peak. On weekdays the store may be busiest at lunch and after work, while on weekends it is usually busiest from afternoon to evening.

2. Forecast Footfall for the Week You Are Scheduling

Use the pattern from step 1 as the base, then adjust for what you know in advance, such as promotions, shopping-centre events or long weekends. This step is the "forecast". It can be done by hand, but gets harder with many branches and many factors at once.

3. Set How Many Customers One Staff Member Can Serve Well

Open the store's own past data, find the periods when conversion rate was good, and see how many customers each staff member handled in those periods. This number is the store's "target ratio". Stores that need a lot of advice, such as eyewear or electrical appliance stores, will have a lower ratio than stores where customers pick up products themselves. In practice, use your own store's figure rather than a figure from elsewhere.

4. Convert to Staff Needed per Period, Then Build the Shifts

Staff needed = forecast footfall ÷ target ratio (rounded up), and never below the minimum number the store needs to open. Then build the actual shifts to cover this number, taking breaks, days off and each person's skills into account.

5. Compare the Plan with What Actually Happened, Then Adjust Next Round

At the end of the week, compare 3 things: forecast footfall against actual, planned staff hours against hours actually used, and conversion rate in each period. If conversion rate improves in the periods where you added staff, you are on the right track. If it does not change, look at other factors such as out-of-stock items or checkout queues.

Worked Example: A Saturday at One Fashion Store

The figures below are hypothetical and are used only to explain the method. The store sets a target ratio of 100 customers per staff member in every 2-hour period, and needs at least 3 staff at all times while open.

Period Forecast footfall Staff needed (÷100, rounded up, minimum 3) Original plan (same all day) Difference from original plan
10:00–12:00 280 3 5 2 over
12:00–14:00 520 6 5 1 short
14:00–16:00 460 5 5 exact
16:00–18:00 720 8 5 3 short
18:00–20:00 640 7 5 2 short
20:00–22:00 250 3 5 2 over
Total (people × periods) 2,870 32 30 –

What you see is that total labour hours barely differ (32 against 30 person-periods), but the distribution is very different. The original plan has too many people in the morning and at closing, and is badly short from 16:00 to 20:00, when customers are most crowded. The fix does not have to be hiring more people. It can be moving shift start times so that the middle and afternoon shifts overlap the evening more.

Can You Schedule Staff with Excel?

Yes. For a store with 1–2 branches, Excel or Google Sheets can handle all of the steps above.

  1. Sheet 1: paste past hourly footfall, split by day of the week.
  2. Sheet 2: calculate the average for each day and time slot, then adjust using the event calendar.
  3. Sheet 3: add the formula =MAX(minimum, ROUNDUP(footfall/target ratio, 0)) to get the staff needed.
  4. Sheet 4: the actual shift table, then count how many people are on each period and compare with sheet 3.

The limits of Excel start to show when there are many branches, when data has to be pulled from several systems every week, and when you want to include factors such as weather or seasonality in the forecast. At that point a forecasting system and a central dashboard can remove a lot of manual work.

What Is Workforce Management, and How Does It Relate to Forecasting?

Workforce management is the process of planning to have the right people with the right skills in the right place at the right time. It covers forecasting demand, scheduling, time tracking and measuring results.

Customer-traffic forecasting is the "upstream" of this process. If the forecast is off, even a well-built schedule will be off too. Many stores therefore start by making footfall figures accurate and forecastable, and only then move on to a scheduling system.

Labour Law to Keep in Mind When Changing Shifts

Moving shifts to match customer peaks must stay within the Labour Protection Act B.E. 2541 (1998) and the company's work rules. The directly relevant issues are normal working hours, breaks, overtime and holidays. For example, Section 28 requires the employer to give employees a weekly day off of at least one day per week, with weekly days off no more than six days apart, or the employer and employee may agree in advance to set the weekly day off on any day.

In practice, before changing the shift pattern, have HR check that the new roster complies with the law and company rules, and notify staff in advance as the company requires.

How Does a Visitor Forecasting System Help with Shifts?

Store associate helping a customer try on shoes

IMAS uses the platform of Retail Insight from Norway for visitor forecasting, using past visitor data from the people-counting system together with sales, seasonality and weather.

  • Forecast customer numbers up to 8 weeks ahead, by branch, so shifts can be planned before the roster is published.
  • Recommend staff-hour allocation, showing which periods should have more or fewer people.
  • Track results hourly, comparing visitor numbers, sales and planned staff hours with what was actually used.

All of this data can be viewed together with the XPERIO dashboard, which brings visitor numbers and conversion rates for every branch into one screen.

The system provides figures and recommendations. The branch manager remains the final decision-maker, because the manager knows the on-the-ground context the data cannot see, such as which staff member is best at selling which products, or whether there is a special event at the store that day. The aim is to reduce guesswork, not the role of people.

For multi-branch retail chains, see the overview on the solutions for multi-branch retail page.

Frequently asked questions

−How much past data do I need to schedule staff by customer traffic?

The longer the history, the more fully you can see seasonal patterns and special days. In practice, start with a weekly pattern and refine it as more data builds up.

+If I don't have a people-counting system yet, how do I start?

Start by installing a people-counting system at the entrance to collect hourly data. In the meantime you can keep planning shifts from sales and number of bills as before, but keep in mind that sales do not reflect the periods when customers came in and did not buy.

+What is the difference between a sales forecast and a visitor forecast?

A sales forecast says how much you will sell. A visitor forecast says how many people will come in needing service. Staff scheduling relies mainly on the latter, because staff have to look after everyone who comes in, not only those who buy.

+Will the system schedule shifts in place of the manager?

No. The system gives forecast figures and recommendations on how many people each period needs. The manager still builds the actual shifts and adjusts them to the situation.

+Can I keep using Excel if I have a forecasting system?

Yes. The forecast figures and recommendations from the system can be used with the shift tables the store already uses. Many stores start this way before moving to a full scheduling system.

Want to Know Customer Numbers in Advance and Staff the Floor Just Right?

The IMAS team helps set up the people-counting system, forecasting system and dashboard so branch managers can use them for real shift planning. You can start with a pilot branch. Details and costs are provided in a quotation.

Book a system demo · See the visitor forecasting system

References

  • Labour Protection Act B.E. 2541 (1998), Section 28 (weekly holidays), consolidated version by the Office of the Council of State.
  • Retail Insight AS. Information on visitor forecasting and staff-hour allocation services. Website retailinsight.no