Labour Cost Calculator

Stop finding out your labour cost after the week is done.

The Labour Cost Calculator gives you a complete wage management system built on the MA000009 Hospitality Industry (General) Award — for Australian bars, restaurants, cafés, hotels, and venues.

What's inside (6 sheets):

• Dashboard — Weekly wages total, labour cost %, total hours, and average hourly rate. Live summary by role with status flags against your target.
• Award Rates — MA000009 base rates for all 7 classification levels. Penalty rates auto-calculate: casual (+25%), evening (+15%), Saturday (+25%), Sunday (+50%), public holidays (+125%).
• Roster Builder — 50 employee rows. Enter name, role, employment type, and hours by day. Wages and penalty rates calculate automatically. Labour cost % vs revenue shown live.
• On-Costs Calculator — Annual cost per employee including super (11.5%), workers comp, and leave loading. Pulls from the roster — no double entry.
• Scenario Planner — Model 3 trading scenarios (Conservative / Base / Optimistic) to see total employer cost before you commit to a roster.
• Benchmarks — Australian labour cost benchmarks by venue type with editable targets.

Verify current Award rates at fairwork.gov.au before use.

No subscriptions. No logins. Download once, use forever.

Requires Microsoft Excel or Google Sheets.