Margins and Cost Control
Staff Cost and Rota Margin Calculator
See what an employee really costs for each hour they work once employer NIC, pension and paid holiday are added to the wage, and what a team on that pay pattern means for your labour percentage.
Staff Cost and Rota Margin Calculator
Enter the hourly wage, paid hours a week, how many staff work that pattern and your weekly revenue. The calculator adds employer NIC at 15% above the £96 a week secondary threshold and a 3% auto-enrolment pension contribution, week by week, then compares the team's cost with revenue. Because 5.6 of the 52 paid weeks are holiday, it shows the cost per paid hour and the higher cost per hour actually worked.
The National Living Wage from 1 April 2026 is £12.71/hr for workers aged 21 and over. From 1 April 2027 it's due to rise to £13.21 (accepted by the government on 28 October 2026; the regulations are still to come), so enter £13.21 to cost pay from April 2027.
Paid hours in a normal week for one employee (contracted or average rota hours). Holiday weeks are paid at the same hours, so don't knock them off here: the result works out the hours actually worked.
How many people work this pattern. Used for the labour percentage; NIC and pension are still worked out per person.
Net sales for the site (or the part of the business these staff cover), used for labour as a percentage of revenue.
Customers' tips paid out by an independent troncmaster. They carry no employer NIC or pension and are not a cost to the business, so they show in the employee's earnings only. An employer top-up is wages: enter it in the hourly wage.
Adjust if the role is seasonal (for example 26 weeks for a summer venue). NIC and pension thresholds are applied to each weekly pay period, so a part-year worker gets only the weeks they're paid for. Their holiday builds up in the same proportion, 5.6 weeks for every 52 paid.
Employer NIC is 0% up to £967 a week for employees under 21 and apprentices under 25, and 15% above that. Auto-enrolment starts at 22, so for an under-21 the calculator leaves the 3% pension out; an apprentice aged 22 or over earning at least £10,000 a year is enrolled automatically.
Labour is between 30% and 35% of revenue. Worth watching weekly against covers and sales. The percentage covers only the staff entered here, so add every pay pattern for a whole-site figure. The hours and weeks you enter are paid ones, and 5.6 weeks of every 52 paid are statutory holiday (12.07% of hours worked for irregular-hours and part-year staff), so the cost per hour worked divides the same annual cost by fewer hours. That's the figure to set against what the rota actually covers. NIC and pension are worked out per weekly pay period, on 2026/27 thresholds. The pension assumes the worker is enrolled (automatic from 22 on £10,000 a year or more). Employment Allowance (up to £10,500 a year) reduces the business's total employer NIC bill and isn't deducted per employee here; a company can't claim it if its only director is also the only employee paid above the secondary threshold.
Check your position with a hospitality accounts specialist
A calculator gives you the shape of the answer. Send your figures and we reply within 24 hours; your enquiry is handled by our team.
True staff cost in hospitality: beyond the headline wage
The National Living Wage for workers aged 21 and over is £12.71 an hour from 1 April 2026, due to rise to £13.21 from 1 April 2027 (accepted by the government; the regulations are still to come). The wage is only part of the cost. For a full-time employee on £12.71 paid for 40 hours a week for 52 weeks, holiday weeks included, the annual pay is £12.71 × 40 × 52 = £26,436.80.
Employer National Insurance is 15% of earnings above the secondary threshold, which payroll applies to each pay period: £96 a week, £417 a month or £5,000 a year (2026/27). For that employee, paid weekly, it is (£508.40 minus £96) × 15% = £61.86 a week, £3,216.72 over 52 weeks. For a seasonal worker the weekly threshold matters: 25 hours a week for 26 weeks at £12.71 is £8,261.50 of pay and £864.76 of employer NIC (£33.26 a week), not the £489.23 you get by taking the full £5,000 off half a year's pay. Employees under 21 and apprentices under 25 carry no employer NIC until pay passes £967 a week. Both changes, the rate rising from 13.8% to 15% and the threshold falling from £9,100 to £5,000, were announced at the October 2024 Budget and took effect in April 2025.
Auto-enrolment requires an employer contribution of at least 3% on qualifying earnings between £6,240 and £50,270 a year (2026/27), applied pro rata to each pay period (£120 a week at the bottom of the band). Here that is (£26,436.80 minus £6,240) × 3% = £605.90. The total is £30,259.42 a year, 14.5% more than the pay alone, or £14.55 for each of the 2,080 paid hours. Employment Allowance, up to £10,500 a year, then reduces the business's total employer NIC bill (a company can't claim it if its only director is also the only employee paid above the secondary threshold).
Paid hours aren't hours worked. Employees are entitled to 5.6 weeks' paid holiday a year (capped at 28 days for anyone working more than five days a week), so someone paid for 52 weeks works 46.4 of them: 1,856 hours, not 2,080. Spread over the hours actually worked, the same £30,259.42 is £16.30 an hour, and that's the number to cost a rota against. Irregular-hours and part-year staff build up holiday at 12.07% of hours worked, which comes to the same thing.
Tips paid out through an independent tronc are the customers' money passed to staff. They carry no employer or employee NIC and no pension contribution, and they are not a cost to the business, so the calculator shows them in the employee's earnings but keeps them out of the cost and the labour percentage. They can never count towards the minimum wage. If the business tops up the tronc from its own money, that top-up is pay and attracts NIC. If you'd like the tronc run outside the business, we can run it for you.
The usual way to read labour cost is as a share of net revenue (sales excluding VAT). 30% is a common rule of thumb in hospitality rather than a published standard, and the right level varies with the format: a wet-led pub, a counter-service cafe and a full-service restaurant run very different staffing models. Enter each pay pattern to build up a whole-site figure, and track it weekly against covers and sales.
Payroll for rota-based teams is also where status mistakes start. A zero-hours contract doesn't make someone self-employed: what decides it is how the work is actually done, such as whether you set the hours and they can't send someone else in their place. Casual and zero-hours staff who are employees belong in this calculation and in payroll, not on invoices.
Frequently asked questions
£12.71 per hour for workers aged 21 and over, from 1 April 2026. The rate for 18 to 20 year olds is £10.85, and £8.00 for under-18s and for apprentices who are under 19 or in the first year of their apprenticeship. From 1 April 2027 the rates are due to rise to £13.21, £11.27 and £8.31 (accepted by the government on 28 October 2026; the regulations are still to come).
15% on earnings above the secondary threshold of £5,000 per year (£96 per week, £417 per month), applied to each pay period's earnings. For employees under 21 and apprentices under 25 it is 0% up to £967 a week (£50,270 a year). The rate rose from 13.8% and the threshold fell from £9,100, both announced at the October 2024 Budget and in force from April 2025.
At least 3% of qualifying earnings between £6,240 and £50,270 a year (2026/27), within a total minimum contribution of 8%. Workers aged 22 to State Pension age earning at least £10,000 a year must be enrolled automatically. Younger workers can ask to join, and if they earn more than £120 a week you then have to contribute too.
Tips paid out by an independent troncmaster carry no employer or employee NIC and no pension contribution, so they cost the business nothing in on-costs. Income tax is still due through PAYE. Money the employer adds to the tronc is pay and is NIC-liable.
Around 30% of net revenue is a common rule of thumb, and the calculator flags anything above 35%. It isn't a fixed standard: the right figure depends on the format, the service style and the wage mix, so track it weekly against covers and sales. Use the cost per hour worked, not the hourly wage, when you cost a rota.