Shift planning against the hourly need and the payroll budget
From the need for people for each hour and a set of shift templates (start hour, length, hourly rate) it picks the numbers of shifts per template with the minimum cost at which every hour is covered. It shows person-hours, the cost of the day, the overlap above the need, the uncovered hours, the weekly load and the full-time equivalent, and checks the shift length and the break. It requires a check by a labor-law specialist.
At a glance
- What question does it answer?
- How many shifts of each template are needed to cover hour by hour at the minimum cost.
- What data is needed?
- Need by hour.
- How to read the result?
- Uncovered hours must be zero; the overlap shows the price of the shape of shifts. Example on the default values: Person-hours per day: 56; Cost of the day: RUB 19,600; Shifts per day: 8; Need in person-hours: 45. The figures are illustrative: enter your own to see your result.
Why and how to reason
The hourly need is uneven, shifts are long: some people fall into hours that need fewer. In the example the minimum is 56 person-hours against the need of 45: shifts 2, 1, 3, 2 over four templates, 11 hours of overlap.
When to use it
When building the schedule and the payroll budget; labor norms are checked by a specialist.
How to read the result
Uncovered hours must be zero; the overlap shows the price of the shape of shifts.
Common mistakes
The peak is covered by people on a full shift, breaks are ignored, norms are taken without checking the act.
What data is needed?
- Need by hour.
- Shift templates with rates.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| The start hour of the first need row | h | 10 | For example, 10 for a store that opens at 10:00. The template starts are set in the same hours of the day. The example value is illustrative. |
| Working days per week | days | 7 | How many days a week this pattern repeats. The example value is illustrative. |
| Weekly hours norm per person (a guide) | h | 40 | Only needed for the full-time equivalent. A guide, not a norm: check against the act in force at the date 2026-11-17. The example value is illustrative. |
| Shift length limit (a guide) | h | 12 | For checking templates: longer than the limit is flagged. A guide, not a norm: check against the act in force at the date 2026-11-17. The example value is illustrative. |
| Payroll budget per day | ₽ | 20,000 | With contributions. Empty or 0: no budget check needed. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Condition | in each hour the number of people on shifts is not below the need |
| Objective | the minimum of the sum of “shifts × length × rate” over templates |
| Method | a search over the numbers of shifts per template in the order of start with a cost cut; an uncovered hour costs more than any rate |
| Checks | the shift length against the limit, the break, weekly hours ÷ the norm |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Person-hours per day
- 56The sum of “shifts × length” over templates.
- Cost of the day
- 19,600 ₽
- Shifts per day
- 8
- Need in person-hours
- 45
- Overlap above the need
- 11Person-hours the templates give beyond the need: the price of an inconvenient shape of shifts.
- Uncovered hours
- 0
- Person-hours per week
- 392
- Full-time equivalent
- 9.8Weekly hours ÷ the hours norm per person. Vacations and sick leave are not included.
- Budget against the cost of the day
- +400 ₽
- Needed
- Covered
Data as a table
| Measure | Needed | Covered |
|---|---|---|
| 10:00 | 2 | 2 |
| 11:00 | 2 | 2 |
| 12:00 | 3 | 3 |
| 13:00 | 3 | 3 |
| 14:00 | 3 | 6 |
| 15:00 | 3 | 6 |
| 16:00 | 4 | 6 |
| 17:00 | 5 | 8 |
| 18:00 | 6 | 6 |
| 19:00 | 6 | 6 |
| 20:00 | 5 | 5 |
| 21:00 | 3 | 3 |
Shifts by template
| Template | Shifts | Person-hours | Cost |
|---|---|---|---|
| Shift 8 h from 10:00 | 2 | 16 | 5,600 ₽ |
| Shift 8 h from 12:00 | 1 | 8 | 2,800 ₽ |
| Shift 8 h from 14:00 | 3 | 24 | 8,400 ₽ |
| Shift 4 h from 17:00 | 2 | 8 | 2,800 ₽ |
The calculation is organizational: constraints (shift length, break, weekly norm, night hours, days off) are entered as guides and require a check by a labor-law specialist against the act in force at the date; it does not replace the shift schedule and the order.
A typical mistake: covering the peak with people on a full shift and ignoring breaks. The calculation seeks the minimum cost, and the convenience of the schedule and the wishes of people stay with the manager.
Nuances and limits
- Covering the peak with people on a full shift.
- Ignoring breaks.
- Taking norms without checking the act.