Covers and staff hours, day by day. Which days carry more hours than the work needs, and what that adds up to in a year.
Seven days. One rota.
A normal week, day by day: how many came in, and how many staff hours were on. The starting figures are a restaurant's, so swap in your own.
Starting figures · add your own
CoversStaff hours on
What a good shift manages without rushing. Your call, not ours.
Opening up, prep, closing down, however quiet it is.
With holiday pay and employer costs.
64
Hours a week over what the days need
£46,400
A year, at that pay
rota_v4.xlsxthis week
Mon
Tue
Wed
Thu
Fri
Sat
Sun
What the day needsHours over
Wednesday: napkins folded. Twice. Trevor
Rough sums. Not financial advice. The same week, 52 times. A busy day can't lend its hours to a quiet one, so a short day counts as nothing over, not as a saving.
How this works
Each day needs enough hours for the people coming in at the pace a good shift manages, and never less than the least you can open with. Anything on the rota above that is hours over. The day with the most hours over is lit up.
Hours a day needs = the larger of (covers ÷ covers a staff hour) and the least you can open with Hours over = staff hours on − hours the day needs, if above nothing A year = hours over a week × pay an hour × 52
It doesn't tell you to cut anyone. Hours over on a quiet day can go two ways: fewer hours on, or more people through the door. It leaves out seasons, sickness and the hours that come with keeping good people.
£46,400a year in hours overWed
Or fill the quiet days instead
The customers · Run
Full at peak. Empty the rest.
Family-run accommodation with 30 rooms. The ads were still paying to bring in peak demand while the quiet dates sat empty, so the spend moved to the dates nobody was selling.