Day-of-week and hour indices for schedules
Shows how many times sales on each day of the week are above or below the average day: an index of 1.2 means a fifth above the average. Built from the weeks in the table (untick holiday weeks), optionally also by hour. Needed for the schedule of promotions and mailings (days with an index above one) and as an input to the staffing calculation.
At a glance
- What question does it answer?
- How many times each day of the week and hour is stronger or weaker than the average.
- What data is needed?
- Sales by day of the week for at least four ordinary weeks.
- How to read the result?
- Look at days with an index above the threshold and at the spread between the best and the weakest day: it sets where a promotion will strengthen a strong day and where it will pull up a weak one. Example on the default values: Best day: Sat · 1.49; Weakest day: Mon · 0.71; Spread: best day to weakest: 2.1×; Share of Saturday and Sunday in the week: 39.7%. The figures are illustrative: enter your own to see your result.
Why and how to reason
The day-of-week index shows how many times the sales of that day are above or below the average day. In the example four weeks give indices Mon–Sun 0.71, 0.78, 0.74, 0.85, 1.14, 1.49, 1.29: Saturday is almost twice as strong as Monday.
When to use it
Apply when building the schedule of promotions, mailings and shifts; exclude holiday weeks.
How to read the result
Look at days with an index above the threshold and at the spread between the best and the weakest day.
Common mistakes
They mix holiday and ordinary weeks.
What data is needed?
- Sales by day of the week for at least four ordinary weeks.
- Marks of holiday weeks and weeks with promotions (to be unticked).
- Sales by hour of an ordinary day (optional).
- An example: four weeks, indices Mon–Sun 0.71, 0.78, 0.74, 0.85, 1.14, 1.49, 1.29 (illustrative numbers).
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Index from which a day counts as strong | × | 1 | Usually 1: the day is stronger than the average. Raise it if you need only the strongest days for promotions. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Average by day | the sum of sales of the weekday ÷ the number of weeks |
| Average over all days | the sum of the seven day averages ÷ 7 |
| Index | average by day ÷ average over all days |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Best day
- Sat · 1.49
- Weakest day
- Mon · 0.71
- Spread: best day to weakest
- 2.1×
- Share of Saturday and Sunday in the week
- 39.7 %
- Days with an index above the threshold
- 3The threshold is set in the field above.
- Weeks in the calculation
- 4
- Best hour
- 19–20 · 1.45
Data as a table
| Measure | Index |
|---|---|
| Mon | 0.71 |
| Tue | 0.78 |
| Wed | 0.74 |
| Thu | 0.85 |
| Fri | 1.14 |
| Sat | 1.49 |
| Sun | 1.29 |
Data as a table
| Measure | Index |
|---|---|
| 10–11 | 0.57 |
| 11–12 | 0.79 |
| 12–13 | 0.92 |
| 13–14 | 1.12 |
| 14–15 | 1.04 |
| 15–16 | 0.88 |
| 16–17 | 0.83 |
| 17–18 | 0.95 |
| 18–19 | 1.21 |
| 19–20 | 1.45 |
| 20–21 | 1.33 |
| 21–22 | 0.91 |
Day-of-week indices
| Day | Average | Index | Reading |
|---|---|---|---|
| Mon | 101 | 0.71 | below average |
| Tue | 111 | 0.78 | below average |
| Wed | 105 | 0.74 | below average |
| Thu | 121 | 0.85 | below average |
| Fri | 162 | 1.14 | above average |
| Sat | 212 | 1.49 | above average |
| Sun | 183 | 1.29 | above average |
Exclude holiday weeks, take into account the chain’s days off and the Friday before long weekends; the day index describes an ordinary week.
What to do with the result: schedule promotions and mailings on days with an index above one or, on the contrary, pull up the weak days; for staff convert the indices into traffic.
A typical mistake: mixing holiday and ordinary weeks.
Nuances and limits
- Mixing holiday and ordinary weeks.
- Taking fewer than four weeks.
- Forgetting the chain’s days off and the Friday before long weekends.