Summarize labor cost against sales every week
Every Monday, WebRun opens Restroworks, pulls clocked hours and sales for every shift and outlet from the past week, calculates labor cost as a percentage of sales for each one, flags any shift running over target, and posts the ranked summary to Microsoft Teams with the full breakdown logged to Google Sheets.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I track labor cost against sales for every shift automatically?
Every Monday, WebRun opens Restroworks, pulls clocked hours, wage cost, and sales for every shift and outlet from the past week, and calculates labor cost as a percentage of sales for each one. It flags any shift over its target, posts the ranked summary to Microsoft Teams, and logs the full breakdown to Google Sheets.
- Labor cost against sales is visible by shift every Monday, not discovered at payroll
- Every shift running over its target is flagged instead of averaged away
- 4 weeks of trend ride along, so a slow creep in labor cost is caught early
Built for restaurant chain operations · outlet general managers · restaurant HR and scheduling teams · multi-unit restaurant controllers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.restroworks.comin a real browser with your saved login - no setup, no API keys. -
1
Restroworks - calculate labor cost against sales per shift
restroworks.com How to Automate Restroworks
WebRun opens Restroworks to calculate labor cost against sales per shift. - Open Restroworks and pull clocked hours and wage cost for every shift and outlet over the past 7 days
- Pull the sales total for each matching shift
- Calculate labor cost as a percentage of sales per shift, and flag anything over the outlet's target
Done when Every shift last week has a calculated labor cost percentage against sales.
-
2
Google Sheets - log the full shift breakdown
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the full shift breakdown. - Open the shared labor cost tracker in Google Sheets
- Log the full shift-by-shift breakdown for the week, by outlet
- Keep the prior 4 weeks visible so a rising trend is easy to spot
Done when This week's full shift breakdown is logged with the trailing weeks visible.
-
3
Microsoft Teams - flag shifts running over target
microsoft.com How to Automate Microsoft Teams
WebRun opens Microsoft Teams to flag shifts running over target. - Post the ranked summary to Microsoft Teams, worst outlet-week first
- Call out every shift that ran over its labor cost target
- This is an internal ops summary, so post it straight through
Done when Ops has this week's labor cost summary in Microsoft Teams with over-target shifts called out.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it change any schedule or clocked time?
No. WebRun only reads the clocked hours, wage cost, and sales Restroworks already has. It never edits a schedule, a timesheet, or a shift, so the source records stay exactly as recorded.
How does it decide a shift is over target?
It compares each shift's labor cost percentage against the target already set for that outlet in Restroworks, so a busy outlet with a higher target is not unfairly flagged next to a quieter one with a lower target.
Can it show whether labor cost is trending up or down?
Yes. The Google Sheets tracker keeps the prior 4 weeks visible alongside the current week, so a slow rise in labor cost at one outlet is visible as a trend, not just a single week's number.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.