I built these for my own stores first.
Before any of this was for sale, I was a district manager with the same problems you have. These three tools are what I made to stop doing the work by hand across 50+ stores. They are also the honest answer to whether I can actually do this, which matters more than anything else on this website.
Every store, name and number below is invented. The real versions run on an employer’s data and on named people’s timekeeping, and none of that gets published here at any price. What is real is the shape: what each tool checks, and how it decides something is worth your attention.
One · Punch exceptions
Every morning it reads yesterday’s punches against the schedule and surfaces only what is wrong. Somebody 40 minutes past their scheduled out. A nine-hour shift with an 18-minute break. A manager who never clocked in at all. An 8:00 AM shift punched at 7:58 PM, which is always a mistake and never once a person.
The point is not the list. The point is that nobody reads 23 stores of raw punch data, so nobody used to catch any of it until payroll closed and it was too late to fix.
61 exceptions across 18 stores · 44 at risk of OT · 5 of 23 stores all clear
- Over scheduledR. Delgado clocked out 41 min past scheduled end (2:41 PM vs 2:00 PM)
- Break policyS. Whitcombe worked 7.4h with 0 min break (policy: 30)
- Break policyA. Nakamura worked 9.8h with 18 min break (policy: 30)
- No clock-inK. Osei (manager) was scheduled 1:00 PM but never clocked in
- Late out 15-29mM. Barrantes clocked out 22 min past scheduled end (10:22 PM vs 10:00 PM)
- AM/PM mix-upT. Okafor clocked in 7:58 PM but was scheduled 8:00 AM (12.0h apart, check AM/PM)
- Training mismatchJ. Prieto was scheduled as training but clocked in as regular
- Over scheduledL. Fairweather clocked out 58 min past scheduled end (11:58 PM vs 11:00 PM)
- Break policyD. Mensah worked 6.6h with 0 min break (policy: 30)
Two · Daily operations dashboard
Sales, labor, speed and accuracy for every store and district, pulled automatically each morning rather than assembled by hand. It refreshes on its own, which is the only reason anybody actually looks at it.
This is the one that replaced the Monday report somebody used to rebuild every week. The hours it gave back are the specific hours I mean when I talk about hours.
| District | Sales | Mix | Sales var | Hrs var | Labor % | SPLH | Txns |
|---|---|---|---|---|---|---|---|
| North District | $34,910 | 24.6% | +$5,180 | +3.2 | 25.4% | $102.40 | 2,588 |
| South District | $28,150 | 19.8% | +$1,220 | -6.4 | 22.1% | $98.70 | 2,004 |
| East District | $21,470 | 15.1% | -$640 | -9.1 | 27.8% | $88.30 | 1,612 |
| West District | $26,880 | 18.9% | +$1,470 | +1.8 | 24.0% | $95.10 | 1,933 |
| Central District | $30,470 | 21.5% | +$2,080 | -2.7 | 23.6% | $96.80 | 2,265 |
Three · Food cost variance
Theoretical versus actual usage per item, built from unit pricing and what the POS says you sold. Instead of finding out your food cost moved, you find out that avocado moved it, by $389, for the third week running.
Anything flagged three weeks straight is a process problem rather than a bad count, and it is a different conversation. Knowing which one you are having is most of the job.
Net sales $48,220 · actual 32.9% vs theoretical 30.4% · variance 2.5% · 4 severe, 3 elevated
| Item | Unit | Begin | Purch | End | Actual use | Theo. use | Variance $ | Flag |
|---|---|---|---|---|---|---|---|---|
| Beef, top sirloin prep | BAG | 24 | 80 | 38.4 | 65.6 | 60.1 | +214.40 | Investigate |
| Shrimp, raw peeled | BAG | 102 | 0 | 71 | 31 | 30.8 | +1.90 | |
| Avocado, 48ct | CASE | 5.2 | 18 | 9.1 | 14.1 | 8.2 | +388.60 | Investigate · 3 wks |
| Chicken, boneless thigh | BAG | 149.2 | 310 | 262.8 | 196.4 | 199.1 | -27.40 | |
| Crab, snow cluster | CASE | 4.4 | 0 | 3.6 | 0.8 | 1.4 | -302.10 | Investigate · 3 wks |
| Broccoli, floret | BAG | 5.1 | 20 | 9.8 | 15.3 | 11.9 | +96.20 | Elevated |
| Salmon, 4oz portion | CASE | 6.1 | 8 | 5 | 9.1 | 9 | +4.80 | |
| Egg, hard cooked | PAIL | 2.4 | 4 | 4.3 | 2.1 | 1.9 | +2.30 |
This is what the workshop teaches.
Not these three tools specifically, and not by me building them for you. The workshop is your team learning to make the version of this that fits your operation, using what you already pay for.
See what the workshop covers, or take the free check and find out which of your hours is worth attacking first.
